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

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

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

[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.