Recover Mysql root password

Recovery.md

1. Stopping the mysql daemon

/etc/init.d/mysql stopRun

2. Disable security checks and restart mysql

mysqld_safe --skip-grant-tables &

3. Enter as root (use whatever you want when it asks for a password)

mysql -u root -p

4. Change the root password and exit

use mysql;
update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User="root";
exit;

5. reboot mysql (will re-enable security checks)

sudo service mysql restart