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

This article mainly introduces phpmyadmin how to change the password of the database, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

How does phpmyadmin change the password of the database?

The initial database password is empty.

The first step is to click on the user options in phpMyAdmin.

Select the root localhost user name and click Edit permissions.

At this time will come out to modify the permissions of the page, there are still many options that can be set, regardless of the other, 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 a new password after it is encrypted according to the password you currently set, then your password will be the generated string in the future. If you want to use your own password, 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.

Change the password is basically completed here, but there will be a follow-up problem, change the database password, when you exit phpMyAdmin and then come in, you can not connect to the database. This is because the login information of the database in phpMyAdmin is still the original, 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'] =''inside; change it to the new password you just set, and save the exit.

Once again open phpMyAdmin, has been able to connect normally, change the password completed.

Thank you for reading this article carefully. I hope the article "how to change the password of the phpmyadmin database" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.