Power BI

Under Review

MySQL over SSH connection

Vote (637)

Antons Fedorenko on 28 Jan 2015 18:10:27

Comments (165)

Comments (165)

88b64f0a 1bf3-4cb3-840b-d98cbea9929a on 05 Jul 2020 23:07:17

RE: MySQL over SSH connection

We NEED ssh

26b33ea8 2388-4bf6-9f8d-374f75f1be31 on 05 Jul 2020 23:07:09

RE: MySQL over SSH connection

A colleague
(Brock Ferguson) shared this idea with me and it solved my problem to a certain degree. Here's what we would try first:
Create a new EC2 server.

On this server, setup SSH port forwarding to the RDS via your existing public SSH server:

ssh -iprivate_key.pem -L 3306:rds-hostname.aws.com:3306 username@your-existing-ssh-server

You will need to grant access from this SSH server to your other server via a private key.

Restrict access to your new EC2 server to port 3306, and to only the IP(s) used by Power BI.

Connect to MySQL:

host: IP of new EC2 server
username: RDS user
pass: RDS pass
This should work by granting you access to your private network by using your new EC2 server as a bastion server. New EC2 -> existing SSH server -> RDS.

53d933f7 9823-48c7-89b8-3eb9f3a1298a on 05 Jul 2020 23:07:02

RE: MySQL over SSH connection

This has been Under Review since 2015, can we please get an update on this?

d35bcdd7 2857-4651-99f9-e7b63252f7d7 on 05 Jul 2020 23:03:51

RE: MySQL over SSH connection

ssh please

63dd42a2 31f6-46d7-b891-ba969a2aa438 on 05 Jul 2020 23:03:42

RE: MySQL over SSH connection

For the many asking about mysql and ssh, you can tunnel your connection with Putty and then connect to the db like a local db. Can't say much about auto-update of the data or publishing.

I see other softwares using SSL but not SSH