Steps for WampServer to change Mysql password, wampserver to modify mysql

Steps for WampServer to change Mysql password, wampserver to modify mysql

1. after the installation is successful, go to mysql through phpmyadmin, click the user menu above, and click Edit permission on the user root host localhost. The following is an option to change the password ], enter the password you want, for example, 123456.

2. Now the mysql password has been modified successfully. However, phpmyadmin cannot communicate with mysql. So next we will modify the phpmyadmin configuration file.

3. Enter the wampserver installation directory, such as C:/wamp/apps/phpmyadmin3.5.1.

4. Open the config. inc. php file (www.111cn.net. Modify about 16 lines of code $ cfg ['servers'] [$ I] ['Password'] = 'your password', for example: 123456

5. then go to the directory and open C:/wamp/apps/phpmyadmin3.5.1/libraries/config. default. php file, modify about 215 lines of code $ cfg ['servers'] [$ I] ['Password'] = 'your password'; for example, 123456

Restart wampserver. The password has been modified.
From: http://www.111cn.net/database/mysql/58544.htm

I have installed WampServer, but the mysql root Password is empty. How can I set the root password?

Go to phpadmin, create a database, Set permissions, and set the password.

Modify the client password of the my. ini file.
 
You cannot enter the mysql console after changing the password of WampServer 20i

Just reload it once !!!
If the data in the database is important, we recommend that you back up the data first !!!