Linux Configuration Firewall open port 3306

All operations on this computer are normal after the MySQL server is installed, but the MySQL server is not connected remotely on other machines. shit!

Suspect is a port problem, the result:

Telnet 192.168.1.245 3306

The connection was not found, so the port was restricted by the firewall.

Now all you have to do is open port 3306 in the firewall.

Execution Vi/etc/sysconfig/iptables:

-A rh-firewall-1-input-m state--state new-m tcp-p TCP--dport 3306-j ACCEPT

The following red is the configuration in your own computer

# Firewall configuration written by System-config-firewall
# Manual Customization of this file are not recommended.
*filter
: INPUT ACCEPT [0:0]
: FORWARD ACCEPT [0:0]
: OUTPUT ACCEPT [0:0]
-A input-m State--state established,related-j ACCEPT
-A input-p icmp-j ACCEPT
-A input-i lo-j ACCEPT
-A input-m State--state new-m tcp-p TCP--dport 22-j ACCEPT
-A input-m State--state new-m tcp-p TCP--dport 3306-j ACCEPT
-A input-j REJECT--reject-with icmp-host-prohibited
-A forward-j REJECT--reject-with icmp-host-prohibited
COMMIT

Add this to the sentence, and note that this sentence must be added to the last sentence above. Otherwise it will not take effect.

Also if the other port to the "3306" switch to the appropriate port.

Then reboot the firewall.

Service Iptables Restart

Get!

Linux Configuration Firewall open port 3306