How to change the password of the database in phpmyadmin

##phpmyadminHow to change the password of the database?

Initial Database password is empty.

The first step is to click on User Options in phpMyAdmin.

Select the root localhost username and click Edit Permissions.

At this point, a page for modifying permissions will appear. There are quite a few options that can be set. Ignore the others for the time being. Drag down and there will be an area to modify the password. .

Enter the new password twice. There is a generate button below. This is to generate a new password after encrypting the password you currently set. Then your password will be generated in the future. String, if you just want to use the password you set, then don't click the "Generate" button.

Here we use the password we set and click Execute.

#If a prompt that the password has been changed successfully pops up, it means that the password has been changed successfully.

# Try logging in with the new password on the client and you will find that the password has been changed successfully.

Changing the password is basically completed, but there will be a follow-up problem. I changed the database password. When I exited phpMyAdmin and came in again, I found that I could not connect to the database. This is Because the database login information in phpMyAdmin is still the original, I cannot log in.

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

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

Open phpMyAdmin again, you can connect normally, and the password change is completed.

The above is the detailed content of How to change the password of the database in phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!