Root - password

General support questions including new installations
Post Reply
mrneo
Posts: 1
Joined: 2015/05/15 15:14:19

Root - password

Post by mrneo » 2015/05/15 15:16:13

I've been trying to reset the root password for mysql, but it's not working. I stopped mysql, then used the mysqld_safe --skip-grant-tables & so I could log in without the password. I then used UPDATE user SET password='password' where user='root'; and then flush privileges. I then stopped mysql again, started it normally and tried logging in: mysql -u root -p; using password. I get the error that says ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Any ideas on what's going wrong?

Thanks!
Last edited by mrneo on 2015/06/09 20:57:18, edited 1 time in total.

gerald_clark
Posts: 10642
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: Root - password

Post by gerald_clark » 2015/05/15 15:31:24

Yes. The password column holds an encrypted password.
A simple google search provides many results. Here is one.
http://www.rackspace.com/knowledge_cent ... t-password

Post Reply