1 of 1 people found this helpful
I've done this in the past using PuTTY and port forwarding, then I can connect to the MySQL simply using localhost as the server name...
Thank you very much for the answer. However, I still can´t connect. Here is what I tried
1) I first used Puttygen to convert my PEM file to a puttykey
2) Provided Putty with the hostname: ec2-*******.us-west-2.compute.amazonaws.com
3) Pointed Putty to the location of the new puttykey
4) Gave the SSH tunnel details (source port: 3306 and destination: 127.0.0.1:3306).
5) Opened the connection and logged in - works just fine
Still, when I point to 127.0.0.1:3306 in Tableau after Connection --> MySql, Tableau is still not able to find the server. Did you use the same approach as me in Putty? Thanks.
Thanks again. Seems we have the same settings. I have MySQL workbench running under OSX (Parallels desktop into Tableau), so not able to see if Putty gets in right. It might be something to do with user rights, but I´ve set up my local ip to have access rights to my ec2 instance, so I think not. And also, since no problem from within workbench seems odd that it should be a user setting. I´ve posted for help on the aws forum as well. Would have been nice if that tunnel were handled within the MySQL connection in Tableau.
I was having this issue and was able to resolve it by using a port other than 3306 as the source port in PuTTY. Then use this same port in the Tableau connection. You can find a response I added here to the same issue.
Hope this helps you or others.