How to change the password of MySQLroot in phpMyAdmin

Phpmyadmin: to change the password of a mysql User, note that if you change the password of the user you log on to, you must modify it in The phpmyadmin configuration file after modification, let's take a look. click... phpmyadmin: to change the password of a mysql User, note that if you change the password of the user you log on to, you must modify it in The phpmyadmin configuration file after modification, let's take a look.

Click the "SQL" tab on the top to enter the SQL command input interface. enter the following command:

Update mysql. user set password = PASSWORD ('snsgou $123456 ') where user = 'root ';

Note: If you have changed the root password, you also need to change the password in the phpMyAdmin configuration file. Otherwise, you cannot log on.

Find: $ cfg ['servers'] [$ I] ['password'] = ''; // phprm.com

Change to: $ cfg ['servers'] [$ I] ['password'] = 'snsgou $123456 ';

The new password takes effect after the MySQL service is restarted.

Tutorial URL:

You are welcome to add your _ favorites to the Favorites folder, but please keep the link for this article.