Navicat连接远程Mysql问题

1. 报错10061问题

   解决方法：修改MySQL文件/etc/mysql/mysql.conf.d/mysqld.cnf

   注释掉 “bind-address= 127.0.0.1”

2. 报错1130问题

   更改“mysql”数据库“user”表的“host”项

   sql命令：

   mysql -u root -p  
   use mysql;  
   select 'host' from user where user='root';  
   update user set host = '%' where user ='root';  
   flush privileges;  
   select 'host'   from user where user='root';