Remote MySQL on One-Click LAMP
I set up a LAMP server using the One-Click LAMP application (https://www.vultr.com/docs/one-click-lamp), I successfully SSH'd into the server, and I'm able to run the mysql commands.
However, I can't seem to setup remote-access, it always allows internally connections only.
I run this command:
netstat -plant|grep ":3306"|grep "LISTEN"
and it shows me it's only listening to 127.0.0.1:
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 4179/mysqld
I have tried adding bind-address=0.0.0.0 to the following three locations:
/etc/my.cnf, /etc/mysql/my.cnf, ~/.my.cnf
and I obviously restart mysql service each time (service mysql restart), however, I always receive a time-out connection when I attempt remote access.
And just for good measure, I re-run
netstat -plant|grep ":3306"|grep "LISTEN" and it's still reporting 127.0.0.1
Does anybody have any idea?