0
I get following error when i try to connect via "HeidiSQL" to my database server (local network)
SQL Error (2003): Can't connect to MySQL server on 'X.X.X.X.' (10051)
SSH Connection via Putty works fine. I checked the my.cnf file on the server (Ubuntu), but settings like bind_address are correct.
Is it possible that my wireless modem (SpeedTouch) makes this trouble? (Because my provider changed the download speed) !
BeeS
Posted 2010-10-30T11:14:35.547
Reputation: 1
1
If you can't connect to your server directly, but can connect through a SSH tunnel then usually the server is just only listening on localhost. As far as I know, that is the default on Ubuntu system.
When you say the bind-address is "correct", then I assume you changed it to your public IP address. In that case, make sure you restarted mysqld after you made that change.
Additionally, the listening port (3306 by default) could be blocked in ufw or some other firewall in place.
Der Hochstapler
Posted 2010-10-30T11:14:35.547
Reputation: 77 228
Make sure the SQL server is listening on 0.0.0.0 not localhost, that's a good start – Hygrinet – 2018-08-31T18:11:49.597
+1 for firewall. Also quite likely that skip-networking is enabled in the config. – Garrett – 2011-11-15T17:34:28.033
Ubuntu's default is to just listen on localhost, not to have skip-networking – cpast – 2013-01-02T05:38:36.420
you check heidi forums? http://www.heidisql.com/forum.php?t=5428
– Tommy – 2011-09-14T22:57:08.233