+ Reply to Thread
Results 1 to 4 of 4

Thread: phpMySQL, "No Privileges"?
      
   

  1. #1
    zachev2kool's Avatar
    zachev2kool is offline Sergeant
    Join Date
    Sep 2009
    Posts
    26

    Default phpMySQL, "No Privileges"?

    In phpMyAdmin, I'm in need to create a new database, but under the "Create New Database" space, it says "No Privileges". How do I fix this so that I'm able to create a database? This is also affecting my website account system and I don't think it will work until I have privileges.

    Thank ya,
    Zach
    Animal Crossing Village!
    Your one stop website for the quirky and fun game of Animal Crossing, Animal Crossing Wild World, and Animal Crossing City Folk!
    Check us out now!

  2. #2
    Alien Dude's Avatar
    Alien Dude is offline Lieutenant Colonel
    Join Date
    Apr 2008
    Location
    The Dark Side
    Posts
    557

    Default Re: phpMySQL, "No Privileges"?

    Opperation for creating a database.

    1/ Create a database
    2/"scroll down" to MySQL Users Add New User and Create a username and password ( you do not have to make a new one for every database )
    3/ "scroll down" to Add User To Database in dropdown boxs select the USER and DATABASE you wish to use then click ADD in the screen that then appears click the CHECKBOX next to ALL PRIVILEGES click make changes button then click go back.
    you have now set the privileges for the user database.
    Alien Dude Solutions
    --------------
    Latest Design The External Tile Shop

  3. #3
    zachev2kool's Avatar
    zachev2kool is offline Sergeant
    Join Date
    Sep 2009
    Posts
    26

    Default Re: phpMySQL, "No Privileges"?

    I tried that, but it still says "No Privileges". o_O
    Animal Crossing Village!
    Your one stop website for the quirky and fun game of Animal Crossing, Animal Crossing Wild World, and Animal Crossing City Folk!
    Check us out now!

  4. #4
    Alien Dude's Avatar
    Alien Dude is offline Lieutenant Colonel
    Join Date
    Apr 2008
    Location
    The Dark Side
    Posts
    557

    Default Re: phpMySQL, "No Privileges"?

    Mine say's that to in phpMyAdmin but all my database work. You create a database in MySQL Databases or MySQL Databases wizard then they appear in phpMyAdmin. phpMyAdmin is used for adding / changing tables within a existing database and exporting / importing along with other functions. not for creating database's.
    if you have made a database in MySQL Databases then it will appear in the left panel of phpMyAdmin click on the database will then bring in all the tables for that database into the right panel.
    Alien Dude Solutions
    --------------
    Latest Design The External Tile Shop

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49