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

This article is about how to use phpMyAdmin to change database passwords. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Step one, click the user option in phpMyAdmin

Select the root localhost user name and click Edit permissions

At this time, there will be a page to modify permissions, and there are still many options that can be set. For the time being, no matter what else, drag down, there will be an area to change the password.

Enter the new password twice, and there is a generate button below, which generates the new password after encryption according to the password you currently set, then your password will be the generated string in the future. If you want to use the password set by yourself, then do not click the "generate" button.

Here we will use the password set by ourselves, and then click execute

If the popup indicates that the password has been changed successfully, it means that the password has been changed successfully.

If you try to log in with the new password on the client side, you can find that the password has been changed successfully.

The password modification is basically completed here, but there will be a follow-up problem. The database password will be changed. When you exit phpMyAdmin and come in again, you will find that you can not connect to the database. This is because the login information of the database in phpMyAdmin is still the same, so you can not log in.

Solution:

Open the phpMyAdmin installation directory, find the config.inc.php file, and open it with notepad or other text editor

Find the $cfg ['Servers'] [$I] [' password'] =''in it; change it to the new password you just set, and save and exit

Open phpMyAdmin again. You can connect normally. You can change the password.

Thank you for reading! On how to use phpMyAdmin to change the database password to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

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.