Template:MySQL Configuration

MySQL needs to be setup to accept connections from remote machines. This is not the default behaviour on many distros.

Check the file:

/etc/mysql/my.cnf

and look for the line beginning with:

bind-address=

This should read:

bind-address=

rather than:

bind-address=127.0.0.1 or bind-address=localhost

Remember to restart MySQL if you make changes to this file:

sudo /etc/init.d/mysql restart