Date: 2005-02-01 10:46 Subject: Accessing your MySQL server from a remote machine Security: Public

Tip of the day... many users have trouble accessing their MySQL Server from another machine. Most commonly, they are running the server on a Debian Linux system which, by default, disables networked access to the server - so only local connections are possible.

(the following info is somewhat Debian specific, as it uses paths different from some other distros)

• Go to /etc/mysql/ and edit the my.cnf file.


• Find the line that says skip-networking and comment it out with a # at the start of the line.


• If you want to limit access to one specific interface on the server machine, you can use e.g. bind-address=192.168.0.110.


• If you want to limit access to a number of machines, you can set up your GRANTs accordingly, and/oror set up your firewall rules according to your specific needs. The default MySQL port number is 3306.