How to change mysql password using phpmyadmin

First open phpmyadmin

Click "User" in the picture above, as shown in the picture, you can see all current users

Select the last line, root localhost, click "Edit Permissions", as shown in the picture:

In the pop-up window , keep pulling down to "Change Password", as shown in the picture:

Enter the new password twice and click "Execute";

Note: The "Generate" button refers to the new password generated after encrypting the currently set password, that is, the generated string.

If you want to use the password you set, do not click the "Generate" button.

After the password is successfully changed, visit the website again, and the display will be as shown below:

Methods to solve "Access Denied" Yes, open the installation directory of phpMyAdmin, find the config.inc.php file, open

and find $cfg['Servers'][$i]['password '] = ''; Change the password to the password just in phpmyadmin and save it

##Open phpMyAdmin at this time and you can connect normally

Recommended related articles and tutorials:

phpmyadmin tutorial

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