KNOWLEDGE BASE

MySQL 8.0 Driver Errors Occur Connecting to Data in Tableau Cloud After MySQL Driver Upgrade


Published: 19 Oct 2021
Last Modified Date: 08 Jun 2022

Issue

When connecting live or refreshing data in Tableau Cloud for databases which use the MySQL driver, the following errors occur: 

[MySQL][ODBC 8.0(w) Driver][mysqld-5.x]Malformed packet

Or
[MySQL][ODBC 8.0(w) Driver][mysqld-5.x]Prepared statement needs to be re-prepared

Or
[MySQL][ODBC 8.0(w) Driver][mysqld-5.x]Unsupported command(COM_STMT_PREPARE)

Environment

  • Tableau Cloud
  • MySQL Driver 8.0.26
  • MySQL
  • Amazon Aurora
  • MariaDB

Resolution

Use one of the below options to workaround the problem. 

Option 1 
Use Tableau Bridge with the older compatible driver version (MySQL 8.0.13 or earlier). See Use Bridge to Keep Data Fresh and Plan Your Bridge Deployment for more information. 

Option 2
If possible, upgrade the database version.

Option 3  
Manually refresh the data by downloading the workbook or data source, refresh it in Tableau Desktop using the older driver version (MySQL 8.0.13 or earlier) and republish the workbook or data source to Tableau Cloud. Older MySQL driver versions can be found on the MySQL Product Archives page.

Cause

To address security concerns with the older driver version, the MySQL driver was upgraded to version 8.0.26 in Tableau Cloud. 
Did this article resolve the issue?