1130mysql报错

navicat链接mysql报错1130-hos txxx.xxx.xxx.xxx is not allowed to connect to this MySql server

解决方案：

1、首先登录mysql

[root@VM_1245_centos myproject]# mysql -u root -pEnter password:

2、进入mysql数据库mysql> use mysql;

3、查看mysql数据库系统用户表usermysql> ｓｅｌｅｃｔ host from user where user=‘root‘;

4、修改user表中的Host:mysql> ｓｅｌｅｃｔ host from user where user=‘root‘;

5、最后刷新mysql> flush privileges;

6、再次连接成功