The problem is that you don't have permissions to create the database test2. Therefore you can't grant yourself any permissions on it becuase it does not exist yet.
Have you mysql administrator give you permission to create databases or have him/her create it for you and give you access to it. =C= -----Original Message----- From: Emma Grant [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 4:31 PM To: [EMAIL PROTECTED] Subject: Newbie question Hi, I am just starting out with mysql. MySQL allows anon access so I don't have to log on to the sql just the linu server. I am trying to create a test database 'test2'. I am logged on as my user 'emil' (not root) on a test linux server. When I go to create the database: mySQL> CREATE DATABASE test2; It gives me the following error. Error: 1044: Access denied for user '@localhost' for database test2 I then log in as root and change my privelages: mySQL> GRANT ALL ON test2.* for emil; But still I get the same error when I try to create it. In fact, I can't get on to a database even if the root creates it and then I GRANT the user 'emil' ALL to the newly created database. Can someone direct me in the right place? Thanks, Emma --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php