Enable remote connections to mysql

[omlineweb]

Hi,

How can enable remote connections to mysql database on port 3306

for example for the IP 192.100.172.192

Thanks.

[pud]

Make sure /etc/mysql/my.cnf bind-address is set to 0.0.0.0 (or your interface IP)
Add tcp|in|d=3306|s=*.*.*.* to /etc/csf/csf.allow (set *.*.*.* to your source IP)