` As fas as I understand it, there is no need to say "update mysql.user set ..." because we have to say "use mysql" first. So the update command should know the table user is part of mysql. Right?
I really believe the problem comes from the fact there is know r...@localhost in mysql.user. I have only r...@beryllium and debian-sys-ma...@localhost. I update the password of r...@beryllium and I can login with mysql -u r...@beryllium -p . Is it a normal situation or I should have r...@localhost? Thanks for the help Bern On Wed, Jun 3, 2009 at 5:13 PM, Stackpole, Chris <cstackp...@barbnet.com>wrote: > *>From:* Bernard Fay [mailto:bernard....@gmail.com] > >*Sent:* Wednesday, June 03, 2009 2:59 PM > >*Subject:* Access denied for user 'root'@'localhost' in mysql > > > > > >Hi, > > > >I installed MySQL in Lenny. > >When I try to login in with mysql -u root -p, I receive : > > > >ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: YES) > > > >I tried to reset the password of root by adding skip-grant-tables in > my.cnf then restart mysql. > >I could login in with mysql -u root then I ran the following commands: > > > >mysql> update user set password=password('password') where user='root'; > >mysql> flush privileges; > > > >I removed skip-grant-tables from my.cnf and restarted mysqld. I still > have: > >ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: YES) > > > >Any idea or clues about how to solve this issue? > > > >Thanks, > >Bernard > > Two methods on the same topic. > > 1) What database are you using when you login? If I remember correctly (it > has been a while) > > you need to declare the user table like “update mysql.user set….” And not > just “update user set…” > That may be the problem if it is trying to update the wrong table/database. > > > > 2) Maybe this is one of those multiple-ways-of-completing-the-same-task > kind of scenarios but I reset passwords like so: > SET PASSWORD FOR r...@localhost=password('MyNewPassword'); > > I don’t seem to have problems with it. > > > > Other then the password reset, your methods seem right to me as long as you > are on the localhost. > > > > Hope this helps. > > > > Have fun! > > ~Stack~ >
