Re: Granting privileges

[Todd Cary]

Jamie - Two questions: 1) Does "grant all" give the user the rights to create a database. 2) What is the difference between "on * " and "on *.* " 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>>