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.