How to configure phpmyadmin empty password logon

Source: Internet
Author: User
Tags how to use phpmyadmin
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.