Do I need to open incoming or outgoing for remote mysql?

[WebHostPro]

The port that needs to be open for remote mysql, does the firewall on the file server need to have the port open for incoming or outgoing or both.

Even better with cfs how can only allow access to that port from one or two ip's?

:p

 

[chirpy]

Outgoing only needed for a remote MySQL server. In csf.allow:

tcput:d=3306:d=11.22.33.44

that should do it for remove MySQL server IP 11.22.33.44, duplicate the line for additional IPs then restart csf.

 

[WebHostPro]

Perfect, thanks Chirpy!

 

[katmai]

you also need to add on the sql server, assuming that you have csf on it:

tcp:in:d=3306:s=FRONT_END_SERVER_IP

 

[WebHostPro]

you also need to add on the sql server, assuming that you have csf on it:

tcp:in:d=3306:s=FRONT_END_SERVER_IP

Can I do this for a c-class rather then one ip at a time and how would you do this?

Something like? tcp:in:d=3306:s=192.168.254.2/255