Hi Todd,
2003年 8月 4日 月曜日 08:17、Todd Cary さんは書きました: > Jamie - > > <<< > > grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with > grant all; > flush privileges; Flush privileges is not necessary here I believe. Only when you update the privileges 'manually' with INSERT, UPDATE,DELETE Best regards Nils Valentin Tokyo/Japan > > 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 > >>-- -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]