Enabling remote connections to a MySQL server
Tuesday, October 24th, 2006By default MySQL only permits connections from the server on which it resides. Although this makes for good security there may be times when you need to access the database from elsewhere. This might be using ODBC from your office or maybe a script running on a separate web server.
Using a SSH client like PuTTY connect to your MySQL server. You then need to edit /etc/my.cnf (# vi /etc/my.cnf).
Under the [mysqld] section comment or remove the skip-networking line and add the bind-address=IP_of_MYSQLserver line e.g.
[mysqld] datadir=/var/lib/mysql socket=/var/run/mysqld/mysqld.socket bind-address=192.168.99.99 # skip-networkingSave the file then restart the MySQL service (# /etc/init.d/mysqld restart)
Now using the MySQL admin tool of your choice create your user accounts but specify the host that they will be connecting from. For example if you are creating a user that connects from the IP address 80.65.35.43 the username will be in this format: username@80.65.35.43
