How to change the mysql access password under wamp _ php instance

This article describes how to change the mysql access password under wamp in detail. Need a Friend to learn php, use the wamp installation package to build php + apache + mysql environment, wamp official: http://www.wampserver.com/en. however, the default wamp username is 'root' and the password is blank. Now I need to change the password to the desired string. The installation directory of my wamp is "d: \ wamp ".

I searched for it online and tried it many times, some of which were not feasible. for example, I directly modified the "D: \ wamp \ apps \ phpmyadmin3.4.10.1 \ config. inc. php" file

The code is as follows:

$ Cfg ['servers'] [$ I] ['password'] = '';

Change to your own password:

The code is as follows:

$ Cfg ['servers'] [$ I] ['password'] = 'Your password ';

The username remains 'root', and then the wamp is restarted.

Log on to the mysql client first. because the start password is blank, press enter to enter the mysql client. Enter the SQL command: UPDATE user SET Password = PASSWORD ('your password') where USER = 'root'; note that the last semicolon of the SQL command should not be forgotten, otherwise, the SQL statement does not take effect. I have a blog post on the Internet saying that I still need to enter "flush priviliges". Otherwise, the password cannot be saved, but this step is also acceptable. my wamp version is 2.2. Next, modify the config. inc. php file

The code is as follows:

$ Cfg ['servers'] [$ I] ['password'] = '';

Change it to the password you just modified through the command line. Be sure to keep it the same.

The code is as follows:

$ Cfg ['servers'] [$ I] ['password'] = 'Your password ';

The user name remains the same. it is still 'root'. restart wamp!