"Error Code DAFFF161 Access denied for user 'Tableau-user@IP-Address' (using password: NO) Invalid username or password." Connecting to MySQL 5.X using MySQL ODBC Driver 8.x in Tableau Desktop

Дата публикации: Feb 5, 2025

Описание

When attempting to connect to MySQL database version 5.x from Tableau Desktop with the latest MySQL ODBC driver 8.x, the following error may occur:

Error Code: DAFFF161 [MySQL][ODBC 8.3(w) Driver] Access denied for user 'Tableau-user@IP-Address' (using password: NO) Invalid username or password.

Cause

The MySQL ODBC driver (8.X) and the MySQL database version (5.X) are incompatible.

Решение

To connect to an older version (5.x) of MySQL database, install the MySQL ODBC driver version 5.2.7 and connect using Other Databases (ODBC) with Tableau Desktop.

Дополнительные ресурсы

Also see:

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

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

Номер статьи базы знаний

001470895

Эта статья решила вашу проблему?

Оставьте свой отзыв, чтобы мы могли стать лучше!