Recover MySQL Root Password

1. Stop MySQL Server Process
(/etc/init.d/mysql stop)

2. Start the MySQL (mysqld) server

/daemon process with the –skip-grant-tables option so that it will not prompt for password
(mysqld_safe –skip-grant-tables &)

3. Connect to mysql server as the root user
(mysql -u root)

4. Setup new root password
(mysql> use mysql;

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

mysql> flush privileges;

mysql> quit)

5. Exit and restart MySQL server
(/etc/init.d/mysql stop
/etc/init.d/mysql start

mysql -u root -p )