Connecting to MySQL through SSH with Key

[mikeqhu]

Need to connect to mySQL using a private key, but it keeps saying denied. I know I can connect just fine through cmd access or WinSCP or Filezilla, etc. Am I missing something?

[Dave]

Please see the following topic:

Server side connection to mysql via ssh

Currently we make MySQL connections via PHP with PDO on the web server. If you want to go through SSH a special SSH tunnel needs to be setup. Not a very common thing to do even with remote DB servers… Is there a special reason why you want to go through an extra security layer as it will only slows things down…? Maybe @patrick can advise if it can be implemented in Wappler

[mikeqhu]

Also maybe some instructions of how to implement it?

[Freddy_Blockchain]

really not a common way but looks like your mysql is located somewhere else… so try this one:

How to Connect to MySQL via SSH Tunnel in Linux

Or maybe go with VPN so no quirk is needed

[George]

See my other post about autossh:

Server side connection to mysql via ssh

After further investigation - seems that connecting from PHP to MySQL server through SSH is not really a well developed solution. However - you can actually already do it by installing such tunnel on your server first that maps to local post and connect to that port. A good tool for that is autossh Read for background info:

[Teodor]

This has been fixed in Wappler 5.6.0