KNOWLEDGE BASE

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


Published: 19 Oct 2021
Last Modified Date: 22 Oct 2021

Issue

When connecting live or refreshing data in Tableau Online 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 Online
  • 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 Online. 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 Online. 
Did this article resolve the issue?