cygwin mysql forget root password

1，mysqld –skip-grant-tables

2，use mysql

3，update user set password=password(“123″) where user=”root”;

4，flush privileges;

—————–

1，grant select,insert,update,delete  on compatrans.* to ‘reer‘@‘localhost‘ identified by ‘an8g‘;