Keira3 icon indicating copy to clipboard operation
Keira3 copied to clipboard

[FEATURE REQUEST] Mysql Connect over SSH

Open Strange-Account opened this issue 6 years ago • 2 comments

Hi,

it would be nice if the software could allow a mysql connection over ssh.


Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Strange-Account avatar Sep 03 '19 05:09 Strange-Account

You can create a SSH tunnel in your PC using this guide: https://www.linode.com/docs/databases/mysql/create-an-ssh-tunnel-for-mysql-remote-access/

I just tried on Linux with my machine using:

ssh [email protected] -L 3307:127.0.0.1:3306 -N

In this way I created a tunnel between my port 3307 and the server port 3306 (mysql port).

On Keira3 now I can connect on my remote server using Host: 127.0.0.1 (localhost) Port: 3307 (my tunnel) User: remote server mysql user Password: remote server mysql password

Helias avatar Dec 18 '19 10:12 Helias

we could allow this using node-ssh https://www.npmjs.com/package/node-ssh

Helias avatar Jul 30 '23 09:07 Helias