Posted on

Accessing your MySQL server from a remote machine

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.
Posted on