Set iptables in Linux to allow remote access to the MySQL Port

Modify the firewall configuration file: vi/etc/sysconfig/iptables add the following line:-ARH-Firewall-1-INPUT-mstate? StateNEW-mtcp-ptcp? If you want to open port 21 and other dport3306-jACCEPT, you only need to switch 3306 to port 21 to open. After the configuration, restart iptableser to modify the firewall configuration file:
Vi/etc/sysconfig/ IptablesAdd the following line:-A RH-Firewall-1-INPUT-m state? State NEW-m tcp-p tcp? Dport 3306-j ACCEPT
If you want to activate ports such as 21, you only need to replace 3306 with the ports to be opened, such as 21.
After configuration, restart iptable
Service iptables restart
Then you can access Mysql from other machines.
Note:
-A RH-Firewall-1-INPUT-m state -- state NEW-m tcp-p tcp -- dport3306-j ACCEPT
-A RH-Firewall-1-INPUT-j REJECT -- reject-with icmp-host-prohibited-A RH-Firewall-1-INPUT-j REJECT -- reject-with icmp-host-prohibited
Is to reject icmp access. for other messages, the returned host is forbidden to access the error. The line that opens port 3306 must be before icmp-host-prohibited.