Error "Error 1918. Error installing ODBC driver MySQL 8.0 ANSI Driver, ODBC Error 13" When Installing MySQL Driver 8.0.19 For Tableau Desktop

KNOWLEDGE BASE

Error "Error 1918. Error installing ODBC driver MySQL 8.0 ANSI Driver, ODBC Error 13" When Installing MySQL Driver 8.0.19 For Tableau Desktop

Published: 14 Feb 2020
Last Modified Date: 08 Jul 2022

Issue

When installing MySQL Driver version 8.0.19 for Tableau Desktop, the following error appears:

Error 1918. Error installing ODBC driver MySQL ODBC 8.0 ANSI Driver, error 13: The setup routines for the MySQL ODBC 8.0 ANSI Driver ODBC driver could not be loaded due to system error code 126.

Environment

Tableau Desktop
Tableau Server
MySQL

Resolution

Try one of the following two potential workarounds:

Workaround 1
Install Microsoft Redistributable 2015: https://www.microsoft.com/en-us/download/details.aspx?id=48145

Workaround 2
Install the MySQL 8.0.18 driver, instead of 8.0.19 and 8.0.20.

Cause

MySQL driver 8.0.19 and 8.0.20 appears to have issues installing correctly and working properly with Tableau Desktop, and MySQL driver 8.0.18 does not appear to have the same issues.