KNOWLEDGE BASE

Unable to Select Database When Creating a New Workbook on Tableau Server Using MySQL


Published: 05 Jun 2018
Last Modified Date: 06 Jun 2018

Issue

When trying to create a new workbook on Tableau Server, it is impossible to select a MySQL database after connecting to it

Environment

  • Tableau Server 2018.1.1
  • Ubuntu 16.04 LTS
  • MySQL

Resolution

When following the MySQL guide to install drivers, it mentions two drivers installation : UNICODE and ANSI.
Work with your IT team to have only one of the two drivers installed. For example, to uninstall an ODBC 8.0 driver, run the following command: myodbc-installer -r -d -n "MySQL ODBC 8.0" -t "Driver=/usr/local/lib/libmyodbc8a.so"

Cause

There is a conflict between the two drivers when they are installed at the same time. 
Did this article resolve the issue?