In the command and method for changing the root password of Mysql, I mentioned how to use phpmyadmin to change the root password of Mysql. However, when you set the phpmyadmin logon password to a blank password, although you can enter Mysql with a blank password through the Mysql command line, you cannot log on to phpmyadmin with a blank password because phpmyadmin is disabled by default, if you want to allow logon with a blank phpmyadmin password, you need to modify the phpmyadmin configuration.
In the phpmyadmin3 installation and configuration graphic tutorial, I introduced phpmyadmin installation and configuration. As for the phpmyadmin logon password modification interface, I have told you in the command and method for Mysql to change the root password, to allow phpmyadmin to log on with an empty password, modify libraries/config. default. php configuration file (if you use config. inc. if phpmyadmin is installed in php, check it together ).
By default, empty phpmyadmin passwords are disabled for logon. this line is mainly controlled by two global variables in the configuration file libraries/config. default. php, that is
The code is as follows:
$ Cfg ['servers'] [$ I] ['nopassword'] = false;
$ Cfg ['servers'] [$ I] ['allownopassword'] = false;
If these two variables are set to True, phpmyadmin will allow empty passwords to log on, that is, modifying the values in libraries/config. default. php
The code is as follows:
$ Cfg ['servers'] [$ I] ['nopassword'] = true;
$ Cfg ['servers'] [$ I] ['allownopassword'] = true;
At the same time
The code is as follows:
$ Cfg ['servers'] [$ I] ['password'] = '';
The database connection password is set to null.
Notes
1. when phpmyadmin is allowed to log on with a blank password, it is often only modified
The code is as follows:
$ Cfg ['servers'] [$ I] ['allownopassword'] = true;
This is not correct. you cannot log on to phpmyadmin with a blank password. you must modify all the preceding three configuration variables.
2. after modifying the phpmyadmin configuration file config. default. after php, you can log on to phpmyadmin again with a blank password and sometimes cannot log on. this is due to cookie. you need to close the original phpmyadmin logon window and open a new window, this space-time password is no problem.
Now, the configuration method for allowing phpmyadmin to log on with a blank password is described. as long as you study the configuration file config. default. php of phpmyadmin, you will have a lot of gains and will be able to solve many problems.
In the command and method for changing the root password of Mysql, I mentioned how to use phpmyadmin to change the root password of Mysql. However, when you set the phpmyadmin logon password to a blank password, although you can enter Mysql with a blank password through the Mysql command line, you cannot log on to phpmyadmin with a blank password again because phpmyadmin is disabled by default, if you want to allow logon with a blank phpmyadmin password, you need to modify the phpmyadmin configuration.
In the phpmyadmin3 installation and configuration graphic tutorial, I introduced phpmyadmin installation and configuration. As for the phpmyadmin logon password modification interface, I have told you in the command and method for Mysql to change the root password, to allow phpmyadmin to log on with an empty password, modify libraries/config. default. php configuration file (if you use config. inc. if phpmyadmin is installed in php, check it together ).
By default, empty phpmyadmin passwords are disabled for logon. this line is mainly controlled by two global variables in the configuration file libraries/config. default. php, that is
The code is as follows:
$ Cfg ['servers'] [$ I] ['nopassword'] = false;
$ Cfg ['servers'] [$ I] ['allownopassword'] = false;
If these two variables are set to True, phpmyadmin will allow empty passwords to log on, that is, modifying the values in libraries/config. default. php
The code is as follows:
$ Cfg ['servers'] [$ I] ['nopassword'] = true;
$ Cfg ['servers'] [$ I] ['allownopassword'] = true;
At the same time
The code is as follows:
$ Cfg ['servers'] [$ I] ['password'] = '';
The database connection password is set to null.
Notes
1. when phpmyadmin is allowed to log on with a blank password, it is often only modified
$ Cfg ['servers'] [$ I] ['allownopassword'] = true;
This is not correct. you cannot log on to phpmyadmin with a blank password. you must modify all the preceding three configuration variables.
2. after modifying the phpmyadmin configuration file config. default. after php, you can log on to phpmyadmin again with a blank password and sometimes cannot log on. this is due to cookie. you need to close the original phpmyadmin logon window and open a new window, this space-time password is no problem.
Now, the configuration method for allowing phpmyadmin to log on with a blank password is described. as long as you study the configuration file config. default. php of phpmyadmin, you will have a lot of gains and will be able to solve many problems.
