5 Replies Latest reply on Aug 29, 2013 9:25 AM by Robert Morton

    How to connect to MySQL DB in EC2 with Tableau in local machine

    ba s

      Hi all,

       

      I have MySQL in my Amazon EC2 Linux. I want to connect Tableau to MYSQL in amazon EC2 Linux. I am not able to connect it. I can connect tableau to my local machine MySQL successfully. I get this errors

       

      Unable to connect to the ODBC Data Source. Check that the necessary drivers are installed and that the connection properties are valid.

      [MySQL][ODBC 5.2(a) Driver]Can't connect to MySQL server on 'xx.xxx.xxx.xxx' (10061)

       

       

      Unable to connect to the server "xx.xxx.xxx.xxx". Check that the server is running and that you have access privileges to the requested database.

      Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

       

      While in Tableau Step 2: Enter Information to log in to the server

      1. Is it the EC2 linux machine Username or DB username ?

      2. Password is putty file for linux or is it DB password ?

       

      I am completely new to tableau. How to do this ?