PHPMyAdmin

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