Centos7安装MySQL5.6后无法远程访问解决方案

Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
connect timed out

1.添加防火墙端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent

2.查看开发的端口

netstart -anp

3.查询防火墙状态

service firewalld status

4.查询对应端口号

firewall-cmd --query-port=3306/tcp

5.如果显示no，则开启

firewall-cmd --query-port=3306/tcp --permanent

6.重启防火墙

firewall-cmd --reload