Wampserver's MySQL password

Wampserver (Windows Apache MySQL PHP), after running will automatically install PHP to run the required Apache and MySQL. Note that if you have previously installed MySQL independently, it will be overwritten, this time, with the previous MySQL password database can only be doors.

Wampserver after installing MySQL, the default password is empty, NULL, remember.

Of course the program can't just use a blank password for MySQL. Modify the MySQL password method, there are tutorials on the web said to modify My.ini. I do not know what it means to find the installation directory and then find My.ini, or directly in the startup of the wampserver inside the MySQL bar My.ini entry open to modify the password under the client, anyway, the latter's words I modify is unsuccessful, as for the former method, and then slowly go back to find the installation directory is too troublesome.

Pro-tested feasible method is, in the Wampserver, select MySQL, open console, enter the password interface, because the default is a blank password, so no input, direct enter, connect the database successfully. Then enter the code below and write the password for the database you want to set in the ' New password '. Run the script and update the password successfully. Restart the wampserver MySQL service and fix it.

update MySQL. User set Password= password (' new password 'whereuser= ' Root ';

Wampserver's MySQL password