I would like to connect to mysql running on computer B from computer A over the internet.

I think iptables is blocking the connection.

when iptables service is running and I try to connect from computer A;

[root@a ~]# mysql -h 89.xx.xx.xx -u root
ERROR 2003 (HY000): Can't connect to MySQL server on '89.xx.xx.x' (113)

but when i stop iptables and try again;

[root@a ~]# mysql -h 89.xx.xx.xx -u root
ERROR 1045 (28000): Access denied for user 'root'@'mydomain.co.uk' (using password: NO)

it looks like with iptables stopped it's getting through.

i have tried adding permission for port 3306, which is what i believe mysql uses;

[root@b ~]# iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT

but this makes no difference.

does anyone have any ideas - very much appreciated.



Computer B has FC6 2.6.18
[root@b ~]# mysql -V
mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (x86_64) using readline 5.0

dont u need an output statement from source port 3306 as well?

Got it. The ordering of the rules is important. I needed to make my rule first before the blocking rules. This makes it the first rule.

iptables -I INPUT 1 -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT