mysql server 10038,Can't connect to mysql server on *.*.*.*(10038)

ubuntu server16.04.1下安装了MySQL 5.7数据库，然后在windows下通过Navicat for MySQL连接时，出现 Can't connect to mysql server on xxx.xxx.xxx.xxx(10038) 的问题。

1.查看了Linux版本

sudo lsb_release -a

2.首先查看端口是否打开

netstat -an|grep 3306

3.vim my.cnf

将bind-address = 127.0.0.1修改为bind-address = 0.0.0.0

4.重启mysql /etc/init.d/mysql restart 等价于 service mysql restart

5.连接mysql

mysql -u root -p

show databases;

use mysql;

desc user;查看user表里的所有字段

update user set host='%' where user='root';

6.授权

grant all privileges on *.* to root@'%' identified by '123' WITH GRANT OPTION;

7.刷新 flush privileges;

8.防火墙开放端口

服务器的防火墙，需要开启3306端口