Jump to content


grant statement, no database selected ?

  • Please log in to reply
1 reply to this topic

#1 schnitz

  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 06 October 2003 - 12:34 AM

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!


#2 shivabharat

  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 06 October 2003 - 04:56 AM

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.
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users