phpMyAdmin setting of the database password

Modify MySQL database password with phpMyAdmin

There are a lot of ways to modify MySQL database passwords, and here's a simple way to use phpMyAdmin to modify them.

Tools/Materials

• phpMyAdmin Software
• MySQL Database

Method/Step

2. The initial database password is empty.

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

6. Select the root localhost user name and click Edit Permissions.

8. At this point will come out to modify the permissions of the page, which can be set options or more, temporarily regardless of the other, down, there will be a Change password area.

10. Enter two new password, below a Build button, this is based on the password you are currently set to generate a new password, then your password is the generated string, if you want to use your own password, then do not click the "Generate" button.

12. Here we use the password set by ourselves and click on Execute.

14. If the popup password changes the successful prompt, the password has been modified successfully.

16. When the client tries to log in with the new password once, it can be found that the password has been modified successfully.

18. Change the password basic to this completion, but there will be a follow-up problem, modify the database password, when the exit phpMyAdmin and then come in and found that the connection is not on the database, this is because the phpMyAdmin database login information or original, so landing not on.

20. 10

    Workaround: Open the phpMyAdmin installation directory, locate the config.inc.php file, and open it with Notepad or another text editor.

22. 11

    Find the inside $cfg[' Servers ' [$i] [' password '] = '; Change to the new password you just set, save the exit.

24. 12

    Open phpMyAdmin again, can be connected properly, modify the password to complete.

    END

Precautions

• 5th Step When you enter a new password, if you click Generate, the password will be the generated password, and no longer the password you entered.

  

phpMyAdmin setting of the database password