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.