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

This article will explain in detail the method of changing the root password of the database by phpmyadmin. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

First log in to phpmyadmin with your root account, then enter the mysql database, and click "sql" at the top to enter the sql input interface. Enter the following command:

Update user set password=password ('123456') where User='root'

123456 of them are the passwords you want to change, so remember not to manually change the password directly in the database.

Then click "execute" in the lower right corner, and see "affected line x", which means that the modification is successful.

Then go to the libraries directory under the phpmyadmin directory (the new version is this directory, or it may be in the root directory C:\ wamp\ apps\ phpmyadmin3.5.1), and modify the config.default.php file. Find $cfg ['Servers'] [$I] [' password'] =''and change it to $cfg [' Servers'] [$I] ['password'] =' 123456password; 123456 is the password you want.

The new password takes effect after restarting mysql.

At the same time, modify the configuration file of your project (C:\ wamp\ www\ smarthome\ Home\ Conf) config.php in the www directory, and modify the following two items

'DB_USER'= > 'root'' DB_PWD'= > '123456'

Done!

This is the end of this article on "the method of phpmyadmin changing database root password". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

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.