phpMyAdmin directly connected with MySQL, so the security is very critical, some friends in order to map convenience, there is no phpMyAdmin set a login password, so very dangerous, if this address by others know, then your MySQL is over. So for the sake of security, we still have to set a password for phpMyAdmin, in general, this password is the same as the MySQL password, the default state, phpMyAdmin did not open to login to re-enter the function, we can use the following code to open this function:
Open the config.inc.php in the phpMyAdmin root directory and follow the following line changes:
1$cfgservers[$i] [' auth_type ']= ' cookie ';
There are three parameters here, and cookies are one of them, and two of them are config and http,config, which means that the password in the configuration file (that is, the standard way) is not authenticated; http: using HTTP authentication; Cookies: Use cookies to sign in to authentication. If you are using iis+php, HTTP authentication is not valid and this feature can only be used in the Apache server environment. In general, the cookie method is used.