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

The editor will share with you how to change the mysql password in phpmyadmin. I hope you will gain a lot after reading this article. Let's discuss it together.

Click "users" in the above figure, as shown in the figure, you can see all current users

Select the last line, root localhost, and click "Edit permissions", as shown in the figure:

In the pop-up window, drop down all the way to "change password", as shown in the figure:

Enter the new password twice and click "execute"

Note: the "generate" button refers to the new password generated after the currently set password is encrypted, that is, the generated string.

If you want to use your own password, do not click the "generate" button.

After the password has been changed successfully, visit the URL again, as shown in the figure:

The solution to "access denial" is to open the phpMyAdmin installation directory, find the config.inc.php file, and open it.

For example, the current directory is D:\ EasyPHP\ modules\ phpmyadmin3522x181017113550

Find $cfg ['Servers'] [$I] [' password'] =''; change the password to the one just in phpmyadmin and save it

Open phpMyAdmin at this time and you can connect normally

After reading this article, I believe you have a certain understanding of how to change the mysql password in phpmyadmin, want to know more about it, welcome to follow the industry information channel, thank you for reading!

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.