Wampserver Latest Version MySQL modify database password

Because the Wampsever version of the update will cause the previous version of the password modification caused the failure, mainly due to password field changes !

First step into MySQL console

Wamp installed, the database is no password enter the console directly to return to the

The second step uses the update user set Password=password (' password you want to modify ') where user= ' root ';
Note: Do not omit semicolons and quotation marks

如果报错了 不要急  新版本有些变动  

The first two steps completed the password has not yet taken effect need to use the following command to refresh the table flush privileges; So that the password takes effect

If you are using phpMyAdmin to access the database, you also need to modify the configuration files in the Wamp/apps/phpmyadmin
In config.inc.php

$cfg [' Servers '] [$i] [' password '] = ' Your modified database password ';

Save it, you can.

Wampserver Latest Version MySQL modify database password