Home > Article > Backend Development > phpmyadmin download phpmyadmin The real reason why access is denied
I just downloaded the latest version of phpmyadmin
After installing it, enter the user name root and click login (because I am local, so root does not have a password)
The result is always an access denied error
After checking the permission settings, there is no problem. ,
I couldn’t find a good answer online,
It’s the root code, it turns out there is a sentence in the configuration file:
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = false;
In libraries/common Line 886 of .inc.php verifies it. If it is false, if the username is root, the password cannot be empty. Otherwise, verification will not be performed. It is false by default. Just change it to true.
I think this may be because for security reasons, people must set a root password, haha, but I think it is a bit inconvenient during testing. Generally, the local root user is empty
Otherwise, he can set the prompt Change the statement to say that your root password is empty and login is not allowed under the current security level. You can go to XXX and change the settings. This may make it clearer. It is too difficult to find the reason for a single access being denied!
The above introduces the real reasons why phpmyadmin download phpmyadmin access is denied, including the content of phpmyadmin download. I hope it will be helpful to friends who are interested in PHP tutorials.