The method of clearing phpmyadmin login password

This article will explain in detail the method of clearing the phpmyadmin login password for you. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Phpmyadmin connects to the mysql database. For security reasons, empty passwords are not allowed to connect to the database by default. Because the database is generally set password access, but if it is only used in the local environment test, it is not very convenient to fill in the password every once in a while.

If you log in with an empty password without changing the configuration, phpmyadmin will return an error message:

Login without a password is forbidden by configuration (see AllowNoPassword)

We can modify the configuration file of phpmyadmin so that we can connect to the database with an empty password.

The configuration is modified as follows:

For example, the database account is root and 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 values below.

/ / 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 On the method of clearing the phpmyadmin login password to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.