Modify MySQL database password with phpMyAdmin

1
The initial database password is empty.
Modify MySQL database password with phpMyAdmin
2
The first step is to click on the user option in phpMyAdmin.
Modify MySQL database password with phpMyAdmin
3
Select the root localhost user name and click Edit Permissions.
Modify MySQL database password with phpMyAdmin
4
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.
Modify MySQL database password with phpMyAdmin
5
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.
Modify MySQL database password with phpMyAdmin
6
Here we use the password set by ourselves and click on Execute.
Modify MySQL database password with phpMyAdmin
7
If the popup password changes the successful prompt, the password has been modified successfully.
Modify MySQL database password with phpMyAdmin
8
When the client tries to log in with the new password once, it can be found that the password has been modified successfully.
Modify MySQL database password with phpMyAdmin
9
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.
Modify MySQL database password with phpMyAdmin
10
Workaround: Open the phpMyAdmin installation directory, locate the config.inc.php file, and open it with Notepad or another text editor.
Modify MySQL database password with phpMyAdmin
11
Find the inside $cfg[' Servers ' [$i] [' password '] = '; Change to the new password you just set, save the exit.
Modify MySQL database password with phpMyAdmin
12
Open phpMyAdmin again, can be connected properly, modify the password to complete.

Modify MySQL database password with phpMyAdmin