Reset the MySQL password

You forgot your MySQL password. No problem, you can recover it easily. Stop the MySQL service with

# /etc/init.d/mysql stop

…and restart it without a password:

# mysqld_safe –skip-grant-tables &

You’ll get an output similar to [1] 5958. Now press Enter and type the following one after the other:

# mysql -u root

mysql> use mysql;

mysql> update user set password=PASSWORD(”NEW-ROOT-PASSWORD”) where User=’root’;

mysql> flush privileges;

mysql> quit

# /etc/init.d/mysql restart

It’s all done now and you should be able to login with the new password.