search

azerothcore / Keira3

Cross-platform Database Editor for AzerothCore
https://www.azerothcore.org/Keira3
GNU Affero General Public License v3.0
350 stars 146 forks source link

[FEATURE REQUEST] Mysql Connect over SSH #93

Open Strange-Account opened 5 years ago

Strange-Account commented 5 years ago

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!](https://app.bountysource.com/issues/79791365-feature-request-mysql-connect-over-ssh?utm_campaign=plugin&utm_content=tracker%2F139701226&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://app.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F139701226&utm_medium=issues&utm_source=github).
Helias commented 4 years ago

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 root@X.X.X.X -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 commented 1 year ago

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