mysql忘记root密码

1 跳过权限检查启动MySQL
shell>mysqld-nt ––skip-grant-tables
或者shell>mysqld ––skip-grant-tables

2 设置root的新密码
msyql>use mysql;
msyql>update user set password=password("new_pass") where user="root";
msyql>flush privileges;

3 退出重启mysql