KNOWLEDGE BASE

Error "Access denied for user 'tableau@IP-Address' (using password: YES) Invalid username or password." Connecting to MySQL Data Source on Tableau Online


Published: 01 Apr 2019
Last Modified Date: 07 Jan 2020

Issue

When attempting to connect to MySQL from Tableau Online after the driver was upgraded to 8.0, the following error occurs:

[MySQL][ODBC 8.0(w) Driver]Access denied for user 'USER'@'IP_ADDRESS' (using password: YES)

Environment

  • Tableau Online
  • MySQL ODBC 8.0 Driver

Resolution

Try the below workaround options. 

Option 1: Republish the affected content from Tableau Desktop with version 8.0 of the MySQL driver with "Require SSL" enabled and specify the SSL certificate. 

Option 2 Republish with SSLMODE=required or SSLMODE=preferred in odbc-connect-string-extras using a TDC file. See Customize and Tune ODBC Connections for more information.
 

Example customization using TDC: 
<connection-customization class='mysql' enabled='true' version='2019.4'>
  <vendor name='mysql' />
  <driver name='mysql' />
  <customizations>
      <customization name='odbc-connect-string-extras' value='SSLMODE=required'/>
  </customizations>
</connection-customization>

Option 3: Work with your database administrator to assist with investigating the issue on the database. This may involve verifying the correct user permissions are provisioned and remote connections are configured. See Specifying Account NamesTroubleshooting Problems Connecting to MySQL and How to Fix Access Denied Errors in MySQL for more information.

Option 4: Use MySQL driver version 5.3 with Tableau Bridge. For more information see Expand Data Freshness Options by Using Tableau Bridge.
 

Cause

Tableau Online's MySQL ODBC driver was upgraded from version 5.3 to 8.0 with the 2019.4 release. 
Did this article resolve the issue?