Resetting or Changing PHPMyAdmin Password On Linux

Resetting or Changing PHPMyAdmin Password On Linux. Sometimes you might have the problem of resetting your phpmyadmin password. Everytime it makes you to feel big to work.  And some tutorials are not nice to read and follow. because they may suggested the final step mainly. Let me elaborate you in detail.

Just goto your Terminal. Just do the following steps.

Stop the MySQL server to get `mysqld` access to change your admin password.

sudo service mysql stop

Start mysqld to access the mysql table directly without mysql Server.

sudo mysqld --skip-grant-tables &

Login to MySQL as root without providing password. So, if you forget the Root password, you can reset with it.

mysql -u root mysql

Change KVCODES with your new root password

UPDATE user SET Password=PASSWORD('KVCODES') WHERE User='root'; FLUSH PRIVILEGES; exit;  // Change your password instead of KVCODES

Sometimes it wont work, so lets try two more options.

The first alternative option would be the below command.

UPDATE user SET authentication_string=PASSWORD('KVCODES') WHERE User='root'; FLUSH PRIVILEGES; exit; // Change your password instead of KVCODES

And the second alternative method would be like this

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'KVCODES';

Kill mysqld after changing the password

sudo pkill mysqld

Start mysql  and phpmyadmin

sudo service mysql start

Login to phpmyadmin as root with your new password.