schnitz Posted October 6, 2003 Share Posted October 6, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/1118-grant-statement-no-database-selected/ Share on other sites More sharing options...
shivabharat Posted October 6, 2003 Share Posted October 6, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/1118-grant-statement-no-database-selected/#findComment-3794 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.