windows mysql 忘記密碼

open cmd
>> .\mysqld.exe --skip-grant-tables
open a new cmd
>> .\mysql.exe -uroot -p
enter

mysql> update mysql.user set password=PASSWORD('yourpasswd') where User='root';
mysql> flush privileges;