====== MySQL - Password Recovery ======

If you've forgotten your root password, you'll need Linux Root login to reset your MySQL root password.  Here is the steps for resetting forgotten MySQL root password.


First login to your Linux box as a root user, and stop the **mysqld** daemon.

<code bash>
service mysqld stop
</code>

Now, start the **mysqld** daemon without the grant table bypassing authentication.

<code bash>
mysqld_safe --skip-grant-tables &
</code>


The mysqld daemon should have started.  Now login as a root user without the password.

<code bash>
mysql -u root
mysql> use mysql
</code>

Reset the root user password.

<code mysql>
mysql> update user set Password=PASSWORD('new-password') where user='root';
mysql> flush privileges;
mysql> exit;
</code>

Restart the mysqld daemon, so that the new password will take into effect.

<code bash>
service mysqld restart
</code>


===== Other methods to recover the MySQL root password =====

<code mysql /var/lib/mysql/mysql-pass-recover>
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
</code>


Restart mysql with new init file

<code mysql>
chown mysql:mysql /var/lib/mysql/mysql-pass-recover
/etc/rc.d/rc.mysqld stop
sleep 5
killall mysqld; killall mysqld; killall mysqld; killall mysqld;
sleep 5
mysqld_safe --init-file=/var/lib/mysql/mysql-pass-recover &
sleep 5
killall mysqld; killall mysqld; killall mysqld; killall mysqld;
sleep 5
/etc/rc.d/rc.mysqld start
</code>