mysql只能localhost连接，解决不允许其他机器去访问

ERROR 1130: Host ***.***.***.*** is not allowed to connect to this MySQL server?

登陆mysql?
首先 use mysql；?
按照别人提供的方式update的时候，出现错误。?
mysql> update user set host='%' where user = 'root';?
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'?
然后查看了下数据库的host信息如下：?
mysql> select host from user where user = 'root';?

+-------------+------+

| host ? ? ? ?| user |

+-------------+------+

| % ? ? ? ? ? | root |

| 127.0.0.1 ? | root |

| MicroLetter | ? ? ?|

| MicroLetter | root |

| localhost ? | ? ? ?|

+-------------+------+

host已经有了%这个值，所以直接运行命令：?
mysql>flush privileges;?