On Thu, Feb 4, 2010 at 3:24 PM, Nd'wex Common <flexycat@gmail.com> wrote:
Hi,
I have mysql database hosted on a linux server [centos 5.4] and i would like to access the database from another machine from the network i have made the follwing configuration to iptables:
Hi, Is your mysql listening on the network interfaces? Maybe it's bound to loopback interface only. Do a netstat -an | grep 3306 and see if this is the case.
iptables -A INPUT -p tcp -s 202.54.1.50 --sport 1024:65535 -d 202.54.1.20 --dport 3306 -m state --state NEW,ESTABLISHED -j ACCEPT
iptables -A OUTPUT -p tcp -s 202.54.1.20 --sport 3306 -d 202.54.1.50 --dport 1024:65535 -m state --state ESTABLISHED -j ACCEPT
Have you tried testing after flushing all rules? that's the sure-fire way to know if it's your firewall config that's broken. BR, S -- Sent from my socks®