centos7 mysql 2003_远程连接centos7 上的mysql报（ERROR 2003 (HY000): Can't connect to MySQL server on '168.x....

MySQL

数据库

远程连接centos7 上的mysql报(ERROR 2003 (HY000): Can't connect to MySQL server on '168.x.x.x' (10060) )

1.MySQL端口

因为上一篇文章我就已经给MySQL新建了一新用户，且赋予了远程连接数据库的所有权限(GRANT ALL PRIVILEGES ON *.* TO 'newuser' @ '%' IDENTIFIED BY 'newpass' WITH GRANT OPTION;)

且错误是 Cant't connect to MySQL.... 而不是1130 - Host'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server ，所以先排除权限问题，先从端口查起。

shell > netstat -apn 查看所有端口信息，如下图可以看出mysqld服务Listen端口号为3306，当然也可以在MySQL中 mysql > show variables like 'port';