Reset MySQL root password

1. Stop the MySQL server

   sudo service mysql stop

2. Start mysqld

   sudo mysqld --skip-grant-tables &

3. Login to MySQL as root

   mysql -u root mysql

4. Change MYSECRET with your new root password

   UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User='root'; FLUSH PRIVILEGES; exit;

5. Kill mysqld

   sudo pkill mysqld

6. Start mysql

   sudo service mysql start

7. Login to phpmyadmin as root with your new password