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

SSH tunnel - using 127.0.0.1 instead of localhost

bitkidoku posted 4 years ago in Creating a connection
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'
fusioned posted 4 years ago
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 posted 4 years ago
You should specify the SSH host - perhaps you oversaw that input box?
ansgar posted 4 years ago
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.
fusioned posted 4 years ago
Yes this is exactly how I have it - SSH host = server, settings tab hostname/IP to 127.0.0.1

Rapid-eraser posted 4 years ago
did you try this :P
http://www.heidisql.com/forum.php?t=6765#p6765
fusioned posted 4 years ago
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.