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‘; 

cygwin mysql forget root password

标签：sel   --   table   oca   cal   delete   flush   use   com