how to connect remote MySQL through ssh tunneling

Hi there, Do you have all the credentials for your tunnelled connection? Have you used another tool to connect to this MySQL database already?

This PR adds SSH tunnel support for MySQL - at the time, we hadn't tested it so it was closed, but it may be worth looking at if you need that feature

{

"credentials": {

"connectionString": "",

"database": "<database name>",

"host": "<database server address>",

"port": "<database server port>",

"user": "<database user>",

"password": "<database user password>",

"tunnel": "ssh",

"ssh": {

"host": "<ssh server>",

"port": "<ssh port>",

"user": "<ssh user>",

"privateKeyPath": "<USERPATH>/.ssh/id_rsa"

}

},

"database": "mysql"

}

Hi @brainy-raincoat-5393 , After doing a bit of research, I think our mysql connector currently does not support SSH. We use this file to execute queries with mysql. We do not currently pass these variables you are trying to use to the SQL connection:

"tunnel": "ssh", 
"ssh": {
            "host": "<ssh server>", 
            "port": "<ssh port>", 
            "user": "<ssh user>",
            "privateKeyPath": "<USERPATH>/.ssh/id_rsa"
        }

which is why it is failing I believe. I am unclear on the syntax we'd need to support this with our db connector, which uses mysql2. We'd happily review a Pull Request to add this feature!

🤩💕🥰