This is because you want to use Navicat to connect to the database and find that the connection is not
By looking at a lot of data and testing multiple times to find out because the firewall is not configured with Port 3306
Words don't say, open the whole, similarly, 80 port is also configured, first enter the firewall configuration file
shell># Vim/etc/sysconfig/iptables
Add the following two rules:
-A input-m state--state new-m tcp-p TCP--dport 3306-j ACCEPT
-A input-m state--state new-m tcp-p TCP--dport 80-j ACCEPT
Special Note: Many netizens add these two rules to the last line of the firewall configuration, causing the firewall to fail to start
The correct one should be added to the default port 22 below this rule
Add the following firewall configuration file:
Restart the firewall, get it done!
shell> #service iptables Restart
Linux configuration firewall, open 80 port, 3306 port