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
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
MySQL databases earlier than version 5.5
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.
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.
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.
Thank you for providing your feedback on the effectiveness of the article.