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

Published: 22 Nov 2013
Last Modified Date: 20 Mar 2020


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


  • Tableau Desktop
  • MySQL
  • MySQL 5.2 ODBC Connector


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.

Option 3:

  • Install the newest MySQL ODBC driver from MySQL 



This error is a MySQL pass-through error caused by a client/server password hashing algorithm mismatch.
Did this article resolve the issue?