Resetting forgotten phpmyadmin password

Simply change or reset your MySQL root password by doing the following:

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