Shulou(Shulou.com)06/01 Report--

This article mainly introduces the use of phpmyadmin to modify mysql password operation method, the text is very detailed, has a certain reference value, interested friends must read!

First open phpmyadmin

Click "Users" in the above figure, as shown in the figure, you can see all current users

Select the last line, root localhost, click "Edit Permission", as shown in the figure:

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

Enter the new password twice and click Execute.

Note: "Generate" button refers to the new password generated after the password currently set is encrypted, i.e. the generated character string.

If you want to use your own password, do not click the "generate" button.

After the password is successfully modified, visit the website again, as shown in the figure below:

The solution to "access denied" is to open the phpMyAdmin installation directory, find the config.inc.php file, and open it.

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

Open phpMyAdmin at this time, you can connect normally

The above is "using phpmyadmin to modify mysql password operation method" all the contents of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.