XAMPP cannot log on to phpmyadmin by modifying the mysql root Password

Phpmyadmin is a WEB-based mysql database management tool that can perform various operations on the mysql database. However, you must configure the username and logon password in phpmyadmin, if the mysql password is changed, the password in phpmyadmin also needs to be changed.

Xampp/phpMyAdmin/config. inc. the password set in php (empty) conflicts, so that users cannot log on (you can log on to phpmyadmin before the computer restarts, but once the machine restarts, you cannot log on ).

The solution is also simple:

1. Modify the phpmyadmin configuration file in xampp.

Go to the installation directory of xampp, modify the xampp/phpMyAdmin/config. inc. php file, find and set the password to start modification,

For example, $ cfg ['servers'] [$ I] ['Password'] = '000000 ';

2. Clear the browser cache and log on to http: // 127.0.0.1/phpmyadmin/again.

In addition, after clicking "permission", we can see the users of the entire database as follows. You can click "operation" to change the user password again and modify config. inc. php accordingly.

Summary

W

In fact, this is for xampp/phpMyAdmin/config. inc. in php, $ cfg ['servers'] [$ I] ['Password'] = '000000, if you change the user name, you can use $ cfg ['servers'] [$ I] ['user'] = 'your Username.