Page 1 of 1

Enable remote connections to mysql

Posted: 23 Jun 2016, 09:54
by omlineweb
Hi,

How can enable remote connections to mysql database on port 3306

for example for the IP 192.100.172.192

Thanks.

Re: Enable remote connections to mysql

Posted: 23 Jun 2016, 10:33
by 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)