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.