Home >Backend Development >PHP Tutorial >XAMPP changes the root password of mysql phpmyadmin cannot log in_PHP tutorial
XAMPP changes the root password of mysql phpmyadmin cannot log in_PHP tutorial
- WBOYOriginal
- 2016-07-13 10:49:101208browse
phpmyadmin is a WEB version of mysql database management tool. It can perform various operations on the mysql database, but I must configure the user name and login password in phpmyadmin. If the mysql password is changed, it will be changed in phpmyadmin. The password also needs to be changed.
The password (empty) set in xampp/phpMyAdmin/config.inc.php conflicts, making the user unable to log in (you can log in to phpmyadmin before the computer is restarted, but you cannot log in once the machine is restarted).
The solution is also very simple:
1 Modify the configuration file about phpmyadmin in xampp
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';
2 Clear the browser cache and log in again to http://127.0.0.1/phpmyadmin/
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.
Summary
w
In fact, this is the modification of $cfg['Servers'][$i]['password'] = '8888'; in xampp/phpMyAdmin/config.inc.php. You can also use it if you change the user name. $cfg['Servers'][$i]['user'] = 'your username'; modify it like this.