This must be a very elementary question. I am a brand new user. I was able to set the root password and can connect as root with no problem. I created a database named remembrance. Where I got stuck was when I tried creating a user. I tried to do it this way (as root):
grant all on remembrance.* to david identified by '...';
(I put the password instead of ...).
Then I quit and tried:
mysql -u david -p
It prompted me for a password, but when I typed in the same password I had used in the grant command above, it was rejected. If I do:
mysql -u david
I get in fine (but oddly it does not prompt me for a password) but it then does not let me 'use remembrance'. I tried doing the grant again, this time using [EMAIL PROTECTED], but that didn't work either. In fact, it put '[EMAIL PROTECTED]' in the User column of the user table (I expected it to put 'david' in the User column and 'localhost' in the Host column).
This indicates that in the GRANT statement, you typed '[EMAIL PROTECTED]' rather than 'david'@'localhost' (the username and hostname should be quoted separately). Try it again with them quoted separately and the problem should go away.
It will also go away if you delete the anonymous user accounts:
% mysql -p -u root mysql Enter password: (root password here) mysql> DELETE FROM user WHERE User = ''; mysql> FLUSH PRIVILEGES;
What am I doing wrong? This is 3.23.54a which was included in RedHat Linux 9. -- David
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
