7 Replies Latest reply on Nov 3, 2016 12:11 AM by Nicholas John

    Unable to connect to the ODBC Data Source - [MySQL][ODBC 5.3(w) Driver]Can't connect to MySQL server

    Nicholas John

      I'm trying to connect to mySQL from my iMac (sierra 10.12.1) running Tableau (10.0.1).

      I get the following error:

       

      • 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.3(w) Driver]Can't connect to MySQL server on '<my server>' (60)
      • Unable to connect to the server "<my server>". Check that the server is running and that you have access privileges to the requested database.

       

      I installed the drivers from the Tableau site; I can see them in ODBC Manager (this: /usr/local/lib/libmyodbc5w.so, which was created 11 April 2014 at 11:20 it says in my Finder).

      I can ping my server.

       

      Any help would be much appreciated.

      Thanks,

      Nik