I have installed Red Hat 9 and it installs MySQL.  After logging on as root, I did the following:

mysql
mysql> use mysql;
mysql> grant all
-> on *
-> to todd indentified by 'my_password'
-> with grant option;

I then log out of mysql and log out as root.  Logged in as "todd" I type the following:

mysql -u todd -p

I type in my password and I get the following error:

Acess denied for [EMAIL PROTECTED]

When I was in mysql as root, "select * from user" has "todd" listed.

What have I missed?

Todd
--

<<inline: NewLogo.gif>>

Reply via email to