What should I do if 2003 appears when navicat connection fails?

A 2003 (10060) error occurred when navicat connected to mysql

Cause: The firewall is not turned off.

There are two ways to solve this problem:

1. Turn off the firewall

2. Set the firewall open port

Related recommendations: "Navicat for mysql graphic tutorial》

First method:

//停止
systemctl stop firewalld.service
//禁止开机启动
systemctl disable firewalld.service

Second method:

//这里发现防火墙是开启的，再来查看防火墙控制的端口
systemctl status firewalld
//查看防火墙控制的端口，发现我想要监听的8081端口没有开启
firewall-cmd --list-all
//永久开启3306端口
sudo firewall-cmd --zone=public --add-port=3306/tcp --permanent
//重载防火墙
sudo firewall-cmd --reload

The above is the detailed content of What should I do if 2003 appears when navicat connection fails?. For more information, please follow other related articles on the PHP Chinese website!