Home  >  Article  >  Database  >  How to log in to phpmyadmin using an empty password

How to log in to phpmyadmin using an empty password

藏色散人
藏色散人forward
2021-04-26 17:04:213244browse

phpmyadmin

## Method, I hope it will be helpful to friends in need!
phpmyadmin connects to the mysql database. For security reasons,

does not allow the use of empty passwords to connect to the database by default

. Because databases generally have password access set up. But if it is only used for testing in the local environment, you need to fill in the password every once in a while, which is not very convenient.

If you have not modified the configuration and use an empty password to log in, phpmyadmin will return an error message: ######Login without a password is forbidden by configuration (see AllowNoPassword)##### ####We can modify the configuration file of phpmyadmin and set it to use an empty password to connect to the database ############The configuration modification is as follows: ###### ###For example: the database account is root , the password is empty######Open the ###libraries/config.default.php### file in the phpmyadmin installation directory, find the corresponding configuration, and modify it according to the following values. ###
// MySQL user$cfg['Servers'][$i]['user'] = 'root';
// MySQL password$cfg['Servers'][$i]['password'] = '';
// Whether to try to connect without password$cfg['Servers'][$i]['nopassword'] = true;
// whether to allow login of any user without a password$cfg['Servers'][$i]['AllowNoPassword'] = true;
######

The above is the detailed content of How to log in to phpmyadmin using an empty password. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:csdn.net. If there is any infringement, please contact admin@php.cn delete