SSH tunnel - using 127.0.0.1 instead of localhost

[expired user #5046]'s profile image [expired user #5046] posted 14 years ago in Creating a connection Permalink
I started using HeidiSQL recently and I absolutely love it.

When I manually define SSH tunnel using 127.0.0.1 I can connect to the remote Mysql server without problems. But as I understand from the error message* when I try to use HeidiSQL's built in support for SSH tunneling, HeidiSQL makes the tunneling using 'localhost'.

Is there a way to change this default behavior?

* Error message is: Can't connect to MySQL server on 'localhost'
[expired user #5296]'s profile image [expired user #5296] posted 13 years ago Permalink
I would like to 2nd this. I have hosting with a firm which requires users to connect to 127.0.0.1 rather than 'localhost' - and whilst this works fine via a Putty shell tunnel, HeidiSQL tries to connect to localhost regardless of the setting.

If no one responds to this, I will put up a bug report.
ansgar's profile image ansgar posted 13 years ago Permalink
You should specify the SSH host - perhaps you oversaw that input box?
ansgar's profile image ansgar posted 13 years ago Permalink
Eh, not the SSH host - I meant the hostname/ip on the settings tab which needs 127.0.0.1 . Then, set the SSH host to the external server name.
[expired user #5296]'s profile image [expired user #5296] posted 13 years ago Permalink
Yes this is exactly how I have it - SSH host = server, settings tab hostname/IP to 127.0.0.1
Rapid-eraser's profile image Rapid-eraser posted 13 years ago Permalink
did you try this :P
http://www.heidisql.com/forum.php?t=6765#p6765
[expired user #5296]'s profile image [expired user #5296] posted 13 years ago Permalink
Oddly enough, that works.

I already have a number of putty profiles setup for use with tortoiseSVN - and these work with HeidiSQL via plink without an issue. No need to input the username / password / key file here.

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