Antons Fedorenko on 28 Jan 2015 18:10:27
- Comments (178)
RE: MySQL over SSH connection
This feature is badly needed..
RE: MySQL over SSH connection
please add this feature
RE: MySQL over SSH connection
Definitely a need for our BI work.
RE: MySQL over SSH connection
We NEED ssh
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.
RE: MySQL over SSH connection
This has been Under Review since 2015, can we please get an update on this?
RE: MySQL over SSH connection
ssh please
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
RE: MySQL over SSH connection
This would be nice.
RE: MySQL over SSH connection
SSH is a must. Without it I will need to look at other Software