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 > -- > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
