Rest Mysql root Password

Reset Mysql Root Password

1. Kill the mysql daemon by loggin in as root

2. Start mysql in safe mode :

mysqld_safe --skip-grant-tables

3. SSH using another session or login to another terminal
4. Connect to mysql without password, you should be able to get in.
mysql -u root

use mysql;

5.Update the password

update user set Password=PASSWORD('new-password') where user='root';
flush privileges;

You should have the new-password as mentioned above as your new mysql root password, stop mysql and restart it.

You may also like...