Reset root password in MySQL

Today my friend Jobaer asked me to help him reset his password in mysql. He apparently forgot what his password was. And he tried in many ways to reset/change it. None worked. So I decided to give a look.

After a while, I found exactly how to reset mysql password The steps are:

Stop MySQL server.

Code:

sudo /etc/init.d/mysql stop

Start MySQL Daemon with grant table skipping.

Code:


sudo mysqld_safe --skip-grant-tables &

Login to MySQL server using username root

Code:

mysql -u root


now, get inside mysql database where user information is kept.

Code:

use mysql;

After that, simply change the password using this command:

Code:

update user set password=PASSWORD("NEW-PASSWORD") where User='root';

Now, flush privileges

Code:

flush privileges;

And then, restart mysql server.

Code:

/etc/init.d/mysql stop

/etc/init.d/mysql start

Test your mysql Password:

Code:

mysql -u root -p

when asked, enter your new password