SSH tunnel fails if bind address is not 127.0.0.1

User, date	Message
Written by jtnewlands 3 months 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. Username: Password: Remember me

User, date

Message

Written by jtnewlands
3 months 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.