Home / server / Questions / 518281
Accepted
Deniz Zoeteman
Asked: 2013-06-25 23:31:34 +0800 CST

MySQL server refusing external connections

  • 772

My MySQL server running on a Debian VPS is not allowing external connections. I can connect fine locally, but I do not seem to be able to connect to my server from an external host.

I've made sure it was running on port 3306, and it is. I'm clueless as to why this is happening, and it would be great if someone could help with this.

With my MySQL client I used (HeidiSQL) I got the following error:

SQL Error (2003) in statement #0: Can't connect to MySQL server on ' xx.xxx.xxx.xxx' (10061)

mysql

1 Answers

  1. Best Answer

    Have you checked that your my.cnf settings are correct?

    If you have specified "bind-address = 127.0.0.1" in the my.cnf

    Then your MySQL - server only listens localhost and does not allow remote-connections. It is the default settings in modern MySQL installions.

    • 7