Home>Article>Database> How to change mysql password in phpmyadmin

How to change mysql password in phpmyadmin

王林
王林 Original
2019-12-05 16:18:28 2327browse

How to change mysql password in phpmyadmin

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

How to change mysql password in phpmyadmin

Select the last row, Root localhost, click "Edit Permissions", as shown in the picture:

How to change mysql password in phpmyadmin

In the pop-up window, scroll down all the way to "Change Password", as shown in the picture:

How to change mysql password in phpmyadmin

Enter the new password twice and click "Execute";

Note: The "Generate" button refers to the encryption of the currently set password. The new password is the generated string.

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

How to change mysql password in phpmyadmin

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

How to change mysql password in phpmyadmin

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

If the current directory is: D:\EasyPHP\modules\phpmyadmin3522x181017113550

How to change mysql password in phpmyadmin

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

How to change mysql password in phpmyadmin

Open phpMyAdmin at this time and you can connect normally

How to change mysql password in phpmyadmin

Recommended related articles and tutorials:

phpmyadmin tutorial

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn