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

KNOWLEDGE BASE

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

Published: 11 Nov 2019
Last Modified Date: 08 Jun 2022

Issue

When connecting from Tableau Cloud 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 Cloud
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 Cloud 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.