By default, PhpMyadmin does not allow empty passwords to log on. Therefore, it is very reasonable to use PhpMyadmin on the server. However, if we test it in a local environment, it may be troublesome, so how can we solve this problem? The following is a small series of solutions for you... by default, PhpMyadmin does not allow empty passwords to log on. Therefore, it is very reasonable to use PhpMyadmin on the server. However, if we test it in a local environment, it may be troublesome, so how can we solve this problem? The following is a small series of solutions for you.
After mysql is installed in Windows or Linux, the default password is blank. when we install the mysql management tool again, "empty password logon is forbidden, for more information, see allow the password to be blank and cannot log on successfully.
The solution is as follows:
1. if you want to use a blank password
Config. inc. php (root directory) or config. default. php (Root Directory)
Then:Librariesconfig. default. php
Tip:Because different versions may involve different files, they are basically $ cfg ['servers'] [$ I] ['allownopassword'] = false;
Change to $ cfg ['servers'] [$ I] ['allownopassword'] = true;
2. if you want to set a password that is not empty, set
$ Cfg ['blowfish _ secret '] = '000000'; // use here a value of your choice the password you want to set
3. after setting, let's set the phpmyadmin timeout time.
Find the phpMyAdmin/libraries/config. default. php file, open, modify
$ Cfg ['logincookievalidity '] = 1440; change 1440 to a larger value.
Note:$ Cfg ['logincookievalidity '] cannot be greater than php. session in ini. the value of gc_maxlifetime; otherwise, "Your PHP configuration parameter session will appear in phpmyadmin. gc_maxlifetime (external link, English) is shorter than the cookie validity period you set in phpMyAdmin. Therefore, the validity period of your logon session will be shorter than the time you set in phpMyAdmin, "error.
Supplement:Modify php. ini and find: session. gc_maxlifetime = 1440. change the value to a larger value and make it take effect.
Article link:
Save this article for favorites!