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.
Thank you for providing your feedback on the effectiveness of the article.