Jump to content

Archived

This topic is now archived and is closed to further replies.

schnitz

grant statement, no database selected ?

Recommended Posts

Hi everyone,

 

I\'m new to PHP & MySQL and just installed MySQL (woohoo). Everything seemed to be going well until I ran into a problem:

 

I created a database (called amel_db) and then wanted to create a user (called \"king\") so I inputted this statement:

 

GRANT SELECT, INSERT, UPDATE, DELETE ON amel_db TO king@localhost IDENTIFIED BY \"frog65\";

 

Here is the result:

 

ERROR 1046: No Database Selected

 

Any ideas?

 

Thanks in advance to all you veterans!

 

schnitz

Share this post


Link to post
Share on other sites

Not sure if this will help because you statement looks fine to me

 

GRANT SELECT, INSERT, UPDATE, DELETE ON amel_db.* TO king@localhost IDENTIFIED BY "frog65"; 

 

Ensure that you are logged in a super user and also check the MYSQL database \"USER\" table and see if you have given them the needed permission.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.