KNOWLEDGE BASE

Error: "[MySQL][ODBC 8.0(w) Driver]Bad Handshake" When Connecting to MySQL from Tableau Online


Published: 11 Nov 2019
Last Modified Date: 02 Dec 2019

Issue

When connecting from Tableau Online to a MySQL database earlier than version 5.5, the following error is returned:

[MySQL][ODBC 8.0(w) Driver]Bad Handshake

Environment

  • Tableau Desktop
  • Tableau Online
  • MySQL databases earlier than version 5.5

Resolution

Solution

Upgrade to a supported version of MySQL 5.5 or later. A list of supported databases and versions can be found on the Technical Specifications page. 

Workaround

As an alternative to upgrading the MySQL database, you can work around this issue by using Tableau Bridge. This will will leverage the drivers installed on the machine running Tableau Bridge. More information about Tableau Bridge can be found on the Expand Data Freshness Options by Using Tableau Bridge page. 

Cause

Tableau Online was upgraded to Driver version 8.0 on 07-Nov-2019. This may cause connectivity issues with unsupported versions of MySQL earlier than 5.5. A list of supported databases and versions can be found on the Technical Specifications page. 
 
Did this article resolve the issue?