distal-attribute
distal-attribute
distal-attribute
distal-attribute

SSH tunnel fails if bind address is not 127.0.0.1

User, date Message
Written by jtnewlands
1 year ago
Category: Creating a connection
1 posts since Thu, 21 Feb 13
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 127.0.0.1?

Thanks!
 

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