Shulou(Shulou.com)06/01 Report--

This article will explain in detail the method of setting login password for phpmyadmin. 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 is directly connected to MYSQL, so security is very critical, some friends for convenience, do not set a login password for phpMyAdmin, this is very dangerous, if this address is known by others, then your MYSQL is over.

Therefore, for security reasons, we still need to set a password for phpMyAdmin. Generally speaking, this password is the same as the MYSQL password. By default, phpMyAdmin does not enable login and re-entry. We can enable this function with the following code:

Open config.inc.php under the root directory of phpMyAdmin and modify it according to the following line:

$cfgServers [$I] ['auth_type'] =' cookie'

There are three parameters here, cookie is one of them, and two of them are config and http

Config means that there is no authentication according to the password in the configuration file (that is, in the standard way).

Http: using HTTP authentication

Cookie: login authentication using COOKIE. If you are using IIS+PHP, HTTP authentication is invalid, and this feature can only be used in an APACHE server environment. In general, the COOKIE method is used.

The phpMyAdmin configuration file is in config.default.php under libraries. The main configurations are as follows:

Generally speaking, if your mysql and phpmyadmin are on the same server, the host name will be directly localhost.

$cfg ['Servers'] [$I] [' host'] = 'localhost'

Then it's time to configure the user name and password for mysql:

$cfg ['Servers'] [$I] [' user'] = 'root';$cfg [' Servers'] [$I] ['password'] = *'. This is the end of the method of setting login password for phpmyadmin. I hope the above content can be helpful to you and learn more. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.