MySQL忘记root密码以及MySQL ERROR 1130

编辑my.ini文件,在mysqlld节点下增加skip-grant-tables 这一行，重启MySQL。
打开DOS窗口，转到mysql\bin目录，输入mysql回车，如果成功，将出现MySQL提示符 。

mysql>use mysql;
mysql>update user set authentication_string=password('root') where user='root' ;
mysql>update user set host = '%' where user = 'root';
mysql>flush privileges;
mysql>select host, user from user;
mysql>quit

报错MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server

mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>flush privileges;
mysql>select host, user from user;
mysql>quit