Shulou(Shulou.com)05/31 Report--

Editor to share with you how to solve the problem that phpMyAdmin cannot log on to MySQL and that empty passwords are prohibited. I believe most people don't know much about it, so share this article for your reference. I hope you can learn a lot after reading this article. Let's learn about it together.

Below by the phpmyadmin tutorial column to introduce phpMyAdmin can not log on to the MySQL server / empty password login is prohibited solution, I hope to help friends in need!

System: Windows

The error is as follows:

I have consulted some materials, and some of them say that the methods are as follows:

Step1: modify the following fields in the config.default.php of F:\ xampp\ phpMyAdmin\ libraries.

Step1:$cfg ['Servers'] [$I] [' password'] =''; / / modify this field to be empty

Step2:$cfg ['Servers'] [$I] [' nopassword'] = true;// modify this field to true

Step3:$cfg ['Servers'] [$I] [' AllowNoPassword'] = true;// modify this field to true

Step4:root users can log in with an empty password. Remember to change the password of the root user.

But after the modification, I still can't log in. Another method is as follows:

Step1: log in to phpMyAdmin with the account password of another superuser

Step2:

Step3: choose to change the password

Step4: fill in the password and re-enter it, and click execute. Do not click to generate password!

Step5: the following information will be displayed after the modification is successful:

Step 6:root users need to have a user whose Host is localhost. (I don't know why I failed to create a user with phpMyAdmin)

Create a new user in PHPMyAdmin: grant all privileges on *. * to 'root'@'localhost' identified by "newpassword" with grant option

Step7: in F:\ xampp\ phpMyAdmin\ libraries\ config.default.php

$cfg ['Servers'] [$I] [' password'] =''

Modified to:

$cfg ['Servers'] [$I] [' password'] = 'newpassword'

Where newpassword is the password of the root user. Restart Apache and mysqld.exe and log in to phpMyAdmin with the new account password.

The above is all the contents of this article entitled "how to solve the problem that phpMyAdmin cannot log on to MySQL and empty passwords are prohibited". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.