Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

SSH tunnel fails if bind address is not

jtnewlands's profile image jtnewlands posted 7 years ago in Creating a connection Permalink
I'm curious why something won't work. I have several servers that have to communicate with each other, so their mysql bind address and their identity in /etc/hosts is their IP. I can ssh to them via putty or plink and then login to mysql as my localhost-only username and password, but when I try to set up a Heidi SQL connection via plink/SSH tunnel I get a 1045 access denied. The standard TCP connection using a user allowed from % works fine. I'd prefer to go through an SSH tunnel.

Is there something about having mysql listen at it's IP address that precludes a SSH tunnel also working at

endo64's profile image endo64 posted 3 years ago Permalink

I have the same problem with the latest version (9.4.0) and I think this happens because of your local MySQL is running and somehow HeidiSQL connects to your local instance whatever your ssh settings are. Even changing your local MySQL port doens't solve the problem, only solution is to stop local instance, then it works.

Please login to leave a reply, or register at first.