KNOWLEDGE BASE

"Error [MySQL][ODBC 5.3(w) Driver] ... plugin not enabled" When Refreshing Extracts in Tableau Server


Published: 15 Dec 2017
Last Modified Date: 15 Dec 2017

Issue

When refreshing MongoDB extracts in Tableau Server, the following error might occur:

Error: [MySQL][ODBC 5.3(w) Driver]Authentication plugin 'mysql_clear_password' cannot be loaded: plugin not enabled. 

Environment

  • Tableau Server 10.3.0
  • Windows 7
  • MongoDB BI Connector

Resolution

Work with your administrator or your IT team to perform the following steps:
  1. On the computer running Tableau Server, set up environmental variable "LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1"
  2. Set up environmental variable in Tableau Server 
Tabadmin stop
Tabadmin set LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN 1
Tabadmin configure
Tabadmin start

Cause

MongoDB connection can be with or without --auth flag enabled.
Did this article resolve the issue?