我的是 centos6.5 ,, iptables 配置如下
filter
INPUT DROP [53:7426]
FORWARD ACCEPT [0:0]
OUTPUT ACCEPT [108:16569]
-A INPUT -p tcp -m tcp --dport 22 -j ACCEPT
-A INPUT -p tcp -m tcp --dport 80 -j ACCEPT
-A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
COMMIT
mysql 的 user 表中:
mysql> select host,user from user;
+-----------+-----------+
| host | user |
+-----------+-----------+
| % | turing |
| 127.0.0.1 | root |
| localhost | root |
+-----------+-----------+
然而事实情况是,当我打开 iptables , mysql 就连接超时,关闭 iptables 就可以正常连接。。。很奇怪。