Go to ...

Techpository

A Better Technical Repository

RSS Feed

MYSQL: Resetting the root user in MYSQL


ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

1.stop mysql service with “service mysqld stop”
2.start mysql service with “/usr/local/mysql/bin/mysqld_safe –skip-grant-tables & ”
3.Login mysql with “mysql -u root -p”
4.These are finished in mysql command line:
USE mysql;
UPDATE user SET Password=PASSWORD(‘newpassword’) where USER=’root’;
FLUSH PRIVILEGES;
quit
5.restart mysql service with “service mysqld restart”

Now you can login with mysql -u root -p

By: ccieyezhu