On Debian (and possibly other OS) the default installation of MySQL will not allow connections from other IP than the local one (127.0.0.1). This a good security measure but if you really need access from outside, follow this:
1) Make sure the port (default MySQL port is 3306) is open in your firewall (iptables). Add the following line to your iptables rules:
2) Edit /etc/mysql/my.cnf. Comment the following line:
bind-address = 127.0.0.1
3) You’ll also need to use a login that can connect from any server.
*EDIT: You have a much more detailed walkthrough here.
1) Make sure the port (default MySQL port is 3306) is open in your firewall (iptables). Add the following line to your iptables rules:
-A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT
2) Edit /etc/mysql/my.cnf. Comment the following line:
bind-address = 127.0.0.1
3) You’ll also need to use a login that can connect from any server.
*EDIT: You have a much more detailed walkthrough here.
No comments:
Post a Comment