This is because the default phpmyadmin null password login is prohibited, if you want to phpmyadmin empty password allow login, you need to modify phpMyAdmin related configuration.
In the phpmyadmin3 installation configuration diagram tutorial, I introduced the phpMyAdmin installation and configuration, as to modify the phpMyAdmin login password interface, I in the MySQL modify the root password command and method has been told, If you want to allow phpMyAdmin to log in with an empty password, modify the libraries/config.default.php configuration file (if you are config.inc.php with the root directory to install phpMyAdmin, please check together).
The default phpMyAdmin null password login is prohibited, which is mainly controlled by two global variables in the configuration file libraries/config.default.php, namely
Copy Code code as follows:
$cfg [' Servers '] [$i] [' nopassword '] = false;
$cfg [' Servers '] [$i] [' allownopassword '] = false;
As long as you modify these two variables, set to True,phpmyadmin will allow the null password to log in, that is, modify the libraries/config.default.php in the
Copy Code code as follows:
$cfg [' Servers '] [$i] [' nopassword '] = true;
$cfg [' Servers '] [$i] [' allownopassword '] = true;
At the same time will
Copy Code code as follows:
$cfg [' Servers '] [$i] [' password '] = ';
The Set database connection password is set to a blank password, which is successful.
Attention matters
1, when allowing phpmyadmin null password login, often only modify
Copy Code code as follows:
$cfg [' Servers '] [$i] [' allownopassword '] = true;
This is wrong, empty password login phpMyAdmin still cannot login, must above three configuration variables are modified.
2, After modifying the phpMyAdmin profile config.default.php, login again with a blank password phpMyAdmin sometimes still unable to log in, this is because of the cookie cause, you need to close the original phpMyAdmin login window, reopen a new window, this time code log There's no problem with the recording.
This allows phpMyAdmin to log on as a blank password configuration method is finished, as long as you study phpMyAdmin configuration file config.default.php, there will be a lot of harvest, can also help you solve a lot of problems.
In MySQL to modify the root password of the command and method, I mentioned the use of phpMyAdmin to modify the MySQL root password method, but when you set the phpMyAdmin login password to a blank password, Although you can enter MySQL with an empty password via the MySQL command-line, you cannot log in phpMyAdmin when you re-enter the blank password, because the default phpmyadmin null password login is prohibited, and if you want to phpmyadmin the null password to allow logon, You will need to modify the phpMyAdmin related configuration.
In the phpmyadmin3 installation configuration diagram tutorial, I introduced the phpMyAdmin installation and configuration, as to modify the phpMyAdmin login password interface, I in the MySQL modify the root password command and method has been told, If you want to allow phpMyAdmin to log in with an empty password, modify the libraries/config.default.php configuration file (if you are config.inc.php with the root directory to install phpMyAdmin, please check together).
The default phpMyAdmin null password login is prohibited, which is mainly controlled by two global variables in the configuration file libraries/config.default.php, namely
Copy Code code as follows:
$cfg [' Servers '] [$i] [' nopassword '] = false;
$cfg [' Servers '] [$i] [' allownopassword '] = false;
As long as you modify these two variables, set to True,phpmyadmin will allow the null password to log in, that is, modify the libraries/config.default.php in the
Copy Code code as follows:
$cfg [' Servers '] [$i] [' nopassword '] = true;
$cfg [' Servers '] [$i] [' allownopassword '] = true;
At the same time will
Copy Code code as follows:
$cfg [' Servers '] [$i] [' password '] = ';
The Set database connection password is set to a blank password, which is successful.
Attention matters
1, when allowing phpmyadmin null password login, often only modify
$cfg [' Servers '] [$i] [' allownopassword '] = true;
This is wrong, empty password login phpMyAdmin still cannot login, must above three configuration variables are modified.
2, After modifying the phpMyAdmin profile config.default.php, login again with a blank password phpMyAdmin sometimes still unable to log in, this is because of the cookie cause, you need to close the original phpMyAdmin login window, reopen a new window, this time code log There's no problem with the recording.
This allows phpMyAdmin to log on as a blank password configuration method is finished, as long as you study phpMyAdmin configuration file config.default.php, there will be a lot of harvest, can also help you solve a lot of problems.
