Home >Database >Mysql Tutorial >How to change the password in phpmyadmin

How to change the password in phpmyadmin

藏色散人
藏色散人Original
2019-11-11 10:53:197261browse

How to change the password in phpmyadmin

How to change the password of phpmyadmin?

Open the main page and enter http://127.0.0.1/home/ , as shown in the figure:

How to change the password in phpmyadmin

Click "open" to open the phpmyadmin interface as shown in the figure:

How to change the password in phpmyadmin

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

How to change the password in phpmyadmin

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

How to change the password in phpmyadmin

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

How to change the password in phpmyadmin

Enter To create a new password twice, 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.

How to change the password in phpmyadmin

#After the password is successfully changed, visit the URL again, and it will be displayed as shown below.

How to change the password in phpmyadmin

The way to solve "Access Denied" is to 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 the password in phpmyadmin

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

How to change the password in phpmyadmin

Open phpMyAdmin at this time and you can connect normally.

How to change the password in phpmyadmin

The above is the detailed content of How to change the 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