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!
Root - password
Root - password
Last edited by mrneo on 2015/06/09 20:57:18, edited 1 time in total.
-
- Posts: 10642
- Joined: 2005/08/05 15:19:54
- Location: Northern Illinois, USA
Re: Root - password
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
A simple google search provides many results. Here is one.
http://www.rackspace.com/knowledge_cent ... t-password