How to make mysql accept connections externally
- by Tam
I have a VPS and I want to make mysql DB accept connection externally (from my PC for instance). I have Debian Linux installed on the server. I checked some tutorials online and they said to comment out:
bind-address = 127.0.0.1
But this didn't seem to help! is there anything specific for VPSs? or Am I missing something else? The command that runs mysql is:
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock