[grant statement, no database selected ?]

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