Additional command line params to specify SSH tunnel settings #2322
Description
Is your feature request related to a problem? Please describe.
To make it as simple as possible - I'm working on application that lists all available web applications with option to automatically open a connection to the database using HeidiSQL. The problem is that all my databases are accessible only behind SSH tunnel. It would be very useful to be able to specify SSH tunnel configuration using command line parameters.
Describe the solution you'd like
A few more command line arguments that would simplify the process of connecting to databases behind SSH tunnel. Maybe something like this:
| Parameter | Short parameter | Description |
|---|---|---|
--ssh-executable |
-se |
SSH executable - full path or only the file name |
--ssh-host |
-sh |
SSH server host |
--ssh-port |
-sP |
SSH server port |
--ssh-local-port |
-sLP |
Local port |
--ssh-user |
-su |
SSH user name |
--ssh-password |
-sp |
SSH user password |
--ssh-key |
-sk |
SSH private key |
--ssh-timeout |
-st |
SSH connection timeout |
Describe alternatives you've considered
I've considered manually creating tunnel using plink.exe or ssh.exe before trying to open HeidiSQL, but it would require me to manage the tunnels by myself - checking if the connection to the DB is still active and then closing it manually. Correct me if I'm wrong - I believe there is already a nice piece of code inside HeidiSQL that does it very well :)
Additional context
I know there is actually a --nettype argument that lets us specify the network protocol type. We can use the "2 = MariaDB/MySQL (SSH tunnel)" according to the Technical help document (section "Command line switches") but there are no SSH tunnel configuration arguments available through command line.