Reset PHPMyAdmin

To reset PHPMyAdmin in Linux:

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
   
   

In Windows, for example my xampp installed in C:\xampp_php5.4\, PHPMyAdmin password is in
C:\xampp_php5.4\phpMyAdmin\config.inc.php