KNOWLEDGE BASE

Error "[Microsoft][ODBC Driver Manager] Data source name not found" Connecting to MySQL


Published: 22 Nov 2013
Last Modified Date: 04 Aug 2017

Issue

When you try to connect to MySQL, the following error 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.

[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.

Unable to connect to the server.

 
In addition, the following error appears in the Tableau Desktop log files:
 
[MySQL][ODBC <version> Driver]Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled
 

Environment

  • Tableau Desktop
  • MySQL
  • MySQL 5.2 ODBC Connector

Resolution

This error is not generated by Tableau Desktop. The following is a list of suggested troubleshooting steps, with background and follow-up information provided in the Additional Information section. Work with your MySQL database administrator to determine the appropriate option.

Option 1:

  1. Reset the MySQL user password, and ensure that it uses the newer hash algorithm.
  2. Try to connect to MySQL again by using the new credentials.

Option 2:

  • Use the MySQL 3.51 ODBC driver to connect to MySQL. For more information, see Drivers & Activation on Tableau website.

Cause

This error is a MySQL pass-through error caused by a client/server password hashing algorithm mismatch.

Additional Information

Did this article resolve the issue?