If you're able to connect to a MySQL instance locally, but not a remote one (in EC2), then my first guess would be that some sort of transport mechanism has not been properly configured on your side on on the EC2 image to allow connectivity.
Put aside Tableau for the moment - are you able to connect to the EC2-hosted MySQL using different tools from your local machine?
No i am not able to connect to Mysql DB in EC2 linux machine. The things i tried are
1.a. In putty used tunneling, source port=33306 (created new rule in firewall)
b. destination gave :127.0.0.1:3306
c. Before gave host name, ppk file as usual saved
2. Downloaded mysql odbc drivers for windows and installed
3. In Win ODBC data source admin in System DSN added the Mysql driver but in the drill down databases are not showing in that window.
4. I checked in my.cnf file in lampp the line bind address is 0.0.0.0 and tried restarting lampp
But i can access phpmyadmin through my browser with <ipaddress>/phpmyadmin
What more can i try to solve this ?@Russell Christopher
OK - based on the "No" you just gave us, you're saying that you cannot connect to your remote MySQL instance on EC with any tool.
That being said, I'm not sure the Tableau forums are the right place to be since MySQL is only one of many data sources we connect to. Have you considered asking this question on a MySQL mailing list or MySQL-specific Q & A board? A site like "serverfault.com" is probably going to have many more people with deep expertise around a mySQL networking issue than this one.
I personally don't know the answer to your question, and maybe someone here happens to - but I think you'll get a more answers if you post in place with more people who are expert in the sort of problem (unrelated to Tableau) that you're having....
@Russell Christopher Thank you, i will try that
There is a known problem with the MySQL v5.2 ODBC driver. Please uninstall that version and install the 32-bit MySQL v5.1 ODBC driver.
I hope this helps,