Add support for MySQL SSH connections to allow remote access to cloud databases

[VanDerLars]

Is your feature request related to a problem? Please describe.

• Add support for MySQL SSH connections to allow remote access to cloud databases

Describe the solution you'd like

• Our database cluster lives inside a private network in a cloud.
• We connect over SSH to a jumphost in order to connect to the database.
• Most DB-Clients support this connection method since the dative mysql-clients support this right away.

Describe alternatives you've considered

• An alternative could be, to setup side-by-side VPN tunnel from the container, in order to make the remote network become part of the container's network.
• 127.0.0.1 or localhost would be the connection then

Additional context

• Here's how Tableplus support this connection method:

[wwwy3y3]

@VanDerLars Thanks for the feature request! We'll see what we could do.

[arthurgavazza]

Hi @wwwy3y3, I'd love to contribute to this project. Would it be okay if I worked on this issue?

[wwwy3y3]

Sure, thanks for contribution! @arthurgavazza assigned!

FYI, we have another PR working on SSL configuration of MySQL data source, you may want to check it out. See if there's any potential conflict. Check PRs related to this issue: https://github.com/Canner/WrenAI/issues/886

[MuzammilMeh]

I am also waiting for features, can anyone update me about it when it completes.

[onlyjackfrost]

@MuzammilMeh