Quickest way to reset mysql root password


If you forgot root password for MySQL, this is the quickest way to reset it. You need to have root access to the box.

service mysql stop

wait until MySQL shuts down. Then run

mysqld_safe --skip-grant-tables &

then you will be able to login as root with no password.

mysql -u root

In MySQL command line prompt issue the following command:

mysql> use mysql;
mysql> UPDATE user SET password=PASSWORD('the_new_password') WHERE user='root';

At this time your root password is reset and MySQL will now know the privileges and you'll be able to login with your new password:

mysql -u root -p