Remote Mysql connection

[umop3plsdn]

I was in a bind this morning so i installed Vicidialnow. What is the quickest way to enable remote mysql connections on a default install whereas the rest of my servers scripts rely on connecting to mysql on the dialer remotely?

[gardo]

What version of VicidialNOW are you using?

[umop3plsdn]

vicidialnow-ce-1.1

[gardo]

You can edit /etc/sysconfig/iptables and uncomment this entry:

#-A RH-Firewall-1-INPUT -m tcp -p tcp --dport 3306 -j ACCEPT

Restart iptables by running this:

service iptables restart

The drawback is this will allow anyone access to your mysql database. I recommend limiting the access to your hosts or network.

[umop3plsdn]

awesome thank you! i didnt even check to see if it was a firewall issue... it's been a long day already.

[rcphq]

Im not used to iptables config,
i did a initial google search and wasn't clear on how i can limit this to just a certain network mask, any help here?
(thanks for the solution!)

You can edit /etc/sysconfig/iptables and uncomment this entry:

#-A RH-Firewall-1-INPUT -m tcp -p tcp --dport 3306 -j ACCEPT

Restart iptables by running this:

service iptables restart

The drawback is this will allow anyone access to your mysql database. I recommend limiting the access to your hosts or network.

[gardo]

You can google more on how to achieve this. There are lots of articles on how to manipulate iptables. Here's an example entry:

-A RH-Firewall-1-INPUT -m tcp -p tcp -s IP_ADDRESS --dport 3306 -j ACCEPT

Where IP_ADDRESS is the IP address you want to allow access to your mysql.

[rcphq]

You can google more on how to achieve this. There are lots of articles on how to manipulate iptables. Here's an example entry:

-A RH-Firewall-1-INPUT -m tcp -p tcp -s IP_ADDRESS --dport 3306 -j ACCEPT

Where IP_ADDRESS is the IP address you want to allow access to your mysql.

thanks!