Connection fail via SSH Tunnel

[expired user #8016]'s profile image [expired user #8016] posted 10 years ago in General Permalink
I want to connect remote Mysql server via SSH Tunnel.

local -> ssh server -> mysql server

but heidisql doesnt try to connect to mysql server

try to connect ssh server local.

plz help me.

best regards
ansgar's profile image ansgar posted 10 years ago Permalink
If it connects to localhost then check your SSH tunnel settings. You could also update to the latest build as I have rewritten the SSH tunnel recently, and you now get messages from the plink command line window as message dialogs. Perhaps when the server provides a new or changed key, then Heidi pops up with a question dialog which you need to confirm first.
[expired user #8016]'s profile image [expired user #8016] posted 10 years ago Permalink
I try to command line

D:\Data\util>plink -L 3307:DB_IP:3306 -P 22 -pw password moh_user@SSH_IP

and access localhost 3307 port number with HeidiSQL.

it works.

and heidiSQL's SSH Tunnel works also.

Did i have to use command line first time?

anyway thx
[expired user #8052]'s profile image [expired user #8052] posted 10 years ago Permalink
You need the server key in your registry. This is done when you first connect to the server.

As ansgar said there should be already a fix to provide a dialog when needed.
[expired user #8203]'s profile image [expired user #8203] posted 10 years ago Permalink
However, if I use the same credentials over SSH via the follow command line:

mysql -u social_shop_prod -h us-east-1.amazonaws.com -p
I can connect successfully and get the MySQL interactive command prompt

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