phpMyAdmin to change the root password cannot be logged in _php tutorial

Previous tests with Ampserv are done directly with the default empty password root account. Today to install an environment does not allow the password is empty, helpless to add a password to root. But found that most of the online tutorials are only to say what method can be modified. But it is seldom described in detail. It took half an hour to find a way. Write here, lest the next forget again. There is only one way: phpMyAdmin

First login to the phpMyAdmin with the root account, then click on the left to enter the MySQL database, click on the top of "MySQL" to enter the SQL input interface. Enter the following command:

Update user set Password=password (' 123456′) where user= ' root '

123456 is the password you wish to change, so remember not to manually change the password in the database directly.

Modify the MySQL database root password

Then click "Execute" in the lower right corner to see the following interface, indicating that the modification was successful.

phpMyAdmin Modify the MySQL database root password successfully.

Don't walk away, it's not over. Then go to the Libraries directory under phpMyAdmin and modify the config.default.php file. Find $cfg[' Servers ' [$i] [' password '] = ',

Modified to $cfg[' Servers ' [$i] [' password '] = ' 123456′; 123456 is the password you want. Now get on the landing and try it.

http://www.bkjia.com/PHPjc/364617.html www.bkjia.com true http://www.bkjia.com/PHPjc/364617.html techarticle previous tests with Ampserv are done directly with the default empty password root account. Today to install an environment does not allow the password is empty, helpless to add a password to root. But found that most of the online teaching ...

