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
