Re: Granting privileges

[Todd Cary]

Jamie - <<< grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with grant all; flush privileges; >>> That definitely works, but what I am not sure about is now -u todd -h localhost has all "Y" in the privileges; before only the first few had "Y". Why is that? Is that due to the "*.*"? Todd Jamie Krasnoo wrote: You still need to flush the privileges. Changes in permissions are not automatically committed. Also you should add the host to the username. grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with grant option; flush privileges; Jamie On Sun, 2003-08-03 at 09:52, Todd Cary wrote: 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>>