KNOWLEDGE BASE

“Drivers not installed…” Error Connecting to MySQL


Published: 09 May 2013
Last Modified Date: 25 Apr 2016

Issue

When you try to connect to MySQL from Tableau Desktop, the following driver-related error message might occur:

An error occurred while communicating with MySQL Database.
The drivers necessary to connect to this database server are not properly installed. Visit http://www.tableausoftware.com/drivers to download driver setup files.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

 

When you try to complete a scheduled data extract refresh in Tableau Server, the following error might occur:

com.tableausoftware.nativeapi.dll.DataSourceException: The drivers necessary to connect to the database server '<server-name>' are not properly installed on Tableau Server. Visit http://www.tableausoftware.com/drivers to download driver setup files.
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Unable to connect to the server "<server-name>". Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Desktop
  • Tableau Server
  • MySQL

Resolution

  • Go to the Download Connector/ODBC page on the MySQL website.
  • Download and install the latest 32-bit ODBC driver MSI installer (5.2.5 is the latest version as of the date of this article).

Cause

The correct 32-bit MySQL driver is not installed.

Additional Information

With the 5.2.4 driver, MySQL made a distinction between the ANSI and Unicode driver, and they appeared as two separate downloads on the MySQL download page. The ANSI driver was not supported and would not work with Tableau products. With the 5.2.5 driver, the two drivers appear to have been combined into a single installer.
Did this article resolve the issue?