newbie q: creating a user

[David Shochat]

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).

What am I doing wrong?
This is 3.23.54a which was included in RedHat Linux 9.
-- David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]