Reset Forgotten phpMyAdmin Password (Step-by-Step Guide)

Forgot your phpMyAdmin password? Follow this simple guide to reset your MySQL root or user password and regain access to phpMyAdmin on localhost or server.

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

  1. Stop the MySQL serversudo service mysql stop
  2. Start mysqld sudo mysqld --skip-grant-tables &
  3. Login to MySQL as root mysql -u root mysql
  4. Change ‘{your_new_password}‘ with your new root password
    UPDATE user SET Password=PASSWORD('{your_new_password}') 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

Comments

comments