- 论坛徽章:
- 0
|
本帖最后由 ltaotao007 于 2011-03-29 11:30 编辑
我的数据库在VPS上
centOS,
mysql5
客户端
mysql -h lcc.com
“221.10.25.6” is not allowed to connect to this mysql server
服务器上抓包如下(证明是已连接到了服务器)
tcpdump tcp port 3306
07:22:30.936521 IP 221.10.25.6.2209 > lcc.com.mysql: S 2194105637:2194105637(0) win 65535 <mss 1460,nop,nop,sackOK>
07:22:30.936619 IP lccall.com.mysql > 221.10.25.6.2209: S 1886073366:1886073366(0) ack 2194105638 win 5840 <mss 1460,nop,nop,sackOK>
07:22:31.054174 IP 221.10.25.6.2209 > lcc.com.mysql: . ack 1 win 65535
07:22:31.055403 IP lccall.com.mysql > 221.10.25.6.2209: P 1:73(72) ack 1 win 5840
07:22:31.055492 IP lccall.com.mysql > 221.10.25.6.2209: F 73:73(0) ack 1 win 5840
07:22:31.177594 IP 221.10.25.6.2209 > lcc.com.mysql: F 1:1(0) ack 73 win 65463
07:22:31.177689 IP lccall.com.mysql > 221.10.25.6.2209: . ack 2 win 5840
07:22:31.177708 IP 221.10.25.6.2209 > lcc.com.mysql: . ack 74 win 65463
firewall如下
Chain INPUT (policy ACCEPT)
num target prot opt source destination
1 acctboth all -- 0.0.0.0/0 0.0.0.0/0
2 ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:3306
Chain FORWARD (policy ACCEPT)
num target prot opt source destination
Chain OUTPUT (policy ACCEPT)
num target prot opt source destination
1 acctboth all -- 0.0.0.0/0 0.0.0.0/0
Chain acctboth (2 references)
num target prot opt source destination
1 tcp -- 116.12.55.12 0.0.0.0/0 tcp dpt:80
2 tcp -- 0.0.0.0/0 116.12.55.12 tcp spt:80
3 tcp -- 116.12.55.12 0.0.0.0/0 tcp dpt:25
4 tcp -- 0.0.0.0/0 116.12.55.12 tcp spt:25
5 tcp -- 116.12.55.12 0.0.0.0/0 tcp dpt:110
6 tcp -- 0.0.0.0/0 116.12.55.12 tcp spt:110
7 icmp -- 116.12.55.12 0.0.0.0/0
8 icmp -- 0.0.0.0/0 116.12.55.12
9 tcp -- 116.12.55.12 0.0.0.0/0
10 tcp -- 0.0.0.0/0 116.12.55.12
11 udp -- 116.12.55.12 0.0.0.0/0
12 udp -- 0.0.0.0/0 116.12.55.12
13 all -- 116.12.55.12 0.0.0.0/0
14 all -- 0.0.0.0/0 116.12.55.12
15 all -- 0.0.0.0/0 0.0.0.0/0 |
|