"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

Knowledge 기사 번호

001470895

이 기사를 통해 문제를 해결했습니까?

개선을 위한 의견을 보내주세요.