How to change the MySQL password through phpmyadmin and solve the problem of phpmyadmin being unable to log in_PHP tutorial

There are many ways to change the mysql password. The most commonly used one is to use phpmyadmin to change the password. If you are like us who don’t know commands, it feels very difficult to change the mysql password in the command mode. Now I will introduce phpmyadmin to change the mysql password. Introduction to password methods.

How to change password

1. Log in to the phpmyadmin console through a browser, click "Permissions",

2. Check the root user and click "Edit Permissions" at the back,

3. In the middle of the opened page, find the "Change Password" column, enter the new password twice, and click the "Execute" button;

Note: after changing the password and then logging in with phpmyadmin, you will be prompted

After fixing the Mysql password in phpMyAdmin, phpMyAdmin cannot log in. The error message is:

Welcome to use phpMyAdmin 2.9.0
Probably reason of this is that you did not create configuration file. You might want to use setup script to create one.
Error

MySQL returns:

#1045 - Access denied for user: 'root@localhost' (Using password: NO)

The solution is

Enter the xampp installation directory, modify the xampp/phpMyAdmin/config.inc.php file, find and set the password to start the modification, for example $cfg['Servers'][$i]['password'] = '8888' ;

In addition, after we click "Permissions", we can see the users of the entire database as follows. We can click "Operation" to modify the user password again and modify config.inc.php accordingly.

http://www.bkjia.com/PHPjc/630685.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630685.htmlTechArticleThere are many ways to change the mysql password. The most commonly used one is to use phpmyadmin to change the password. If you don’t like us, For those who know how to command, it is very difficult to change the MySQL password in command mode...