grant statement, no database selected ?

[schnitz]

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

[shivabharat]

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.