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… 🙂