Resetting phpMyAdmin password

Did you forgot your phpmyadmin password? Struggling to reset?

Okay, let’s see how to reset our phpmyadmin password.

1. First stop your 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 with your new root password

   UPDATE user SET Password=PASSWORD('MY_PASS') 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

That’s all… 🙂