HeidiSQL SSH Tunnel Setup¶

In the ‘Settings’ tab

1. In the dropdown list of ‘Network type’, please select SSH tunnel
2. Hostname/IP: localhost (even you are connecting remotely)
3. Username & Password: your mysql user and password

Next, in the tab SSH Tunnel:

1. specify plink.exe or you need to download it and specify where it’s located
2. Host + port: the remote IP of your SSH server(should be MySQL server as well), port 22 if you don’t change anything
3. Username & password: SSH username (not MySQL users)
4. You might ignore the password in the above step if you have the .ppk file.

Quelle: Connect to MySQL server from HeidiSQL with SSH tunnel

dBeaver SSH Tunnel Setup¶

Convert private key file to open ssh format¹