How to configure to allow phpmyadmin password to log in

Before this site has also introduced the use of phpmyadmin Mysql modify the root password, but when you set the phpmyadmin password is set to a blank password, although you can Mysql command line mode to enter a blank password Mysql, but when you empty again Password login phpmyadmin can not log in, this is because the default phpmyadmin null password login is prohibited, if you want phpmyadmin blank password to allow login, you need to modify phpmyadmin related configuration.

Phpmyadmin3 installation configuration graphic tutorial article, I introduced phpmyadmin installation and configuration, as to modify the phpmyadmin login password interface, I changed the root password in Mysql command and method has been informed, if you want to allow phpmyadmin password to log in , We should modify the libraries / config.default.php configuration file (if you are installing phpmyadmin with config.inc.php in the root directory, please check together).

Default phpmyadmin null password login is prohibited, this behavior is mainly controlled by two global variables in the configuration file libraries / config.default.php, namely

$ cfg ['Servers'] [$ i] ['nopassword'] = false;

$ cfg ['Servers'] [$ i] ['AllowNoPassword'] = false;

Just change these two variables, set to True, phpmyadmin will allow the password to log in, that is, modify the libraries / config.default.php


$ cfg ['Servers'] [$ i] ['nopassword'] = true;

$ cfg ['Servers'] [$ i] ['AllowNoPassword'] = true;

At the same time


$ cfg ['Servers'] [$ i] ['password'] = '';

Set the database connection password is set to a blank password, that is successful.

Precautions

1, phpmyadmin empty password is allowed to log in, often only modify


$ cfg ['Servers'] [$ i] ['AllowNoPassword'] = true;

This is wrong, empty password log phpmyadmin still can not log, you must modify the above three configuration variables.

2, modify the phpmyadmin configuration file config.default.php, re-empty password login phpmyadmin Sometimes still can not log in, this is because the cookie causes, you need to close the original phpmyadmin login window, re open a new window , This time no problem with the password login.

At this point to allow phpmyadmin empty password login configuration method is introduced, as long as you study phpmyadmin configuration file config.default.php, there will be many gains, but also can help you solve many problems.