Open Port 3306 in ubuntu 12.04 to allow connections to mysql from any ip [closed]

Question

I have a mysql server running on a server and I wanted to know how to Open a Port 3306 in ubuntu 12.04 to allow connections to mysql from any ip. Can you help? Thanks

Answer 1

I Don't think firewall is your problem. Any modern mysql version has bind-address=127.0.0.1 in its my.cnf, which makes it bind to loopback only. Comment it out, restart mysql and you should be good to go. Ubuntu doesn't have a restrictive firewall by default IIRC.