Connect to server with two SSH hops

[expired user #9516]'s profile image [expired user #9516] posted 8 years ago in General Permalink

Hello HeidiSQL community,

I am encoutering a problem when I try to connect to a distant database server with the SSH tunnel option. Here is a representation of my specific case :

myDesktop >--------> gateway >--------> RDBMS physical server

I first need to reach the gateway which allows me to then reach the database server (in the same network as the gateway) because filters do not allow direct ssh on the database from the outside.

In order to be able to connect to the database, I currently do the following (with Putty / Windows) :

  1. myDesktop$ ssh gateway_IP@
  2. gateway$ ssh RDBMS_IP@
  3. RDBMS$ mysql --user=root

I'm not sure if it is possible to connect to the Database with HeidiSQL in my particular situation because I need to provide both Mysql credentials and the Physical Server credentials in only one HeidiSQL prompt. When I try with the SSH tunnel option (either with the server or the RDMBS credentials), I end up with a plink error.

Can anyone provide informations on how to do what I would like (even if it involves third party software or ssh commands) ?

Thank you in advance for your help, it would be much appreciated.

Sincerely,

Chris

[expired user #9516]'s profile image [expired user #9516] posted 8 years ago Permalink

Turns out plink is buggy and making the SSH Tunnel unable to work.

Same configuration is working fine with MysqlWorkbench.

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