KNOWLEDGE BASE

MySQL Error "[MySQL][ODBC 8.0(w) Driver]Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection."


Published: 10 Jun 2022
Last Modified Date: 10 Jun 2022

Issue

The following errors occur suddenly when trying to connect to MySQL from Tableau:

[MySQL][ODBC 8.0(w) Driver]Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
[MySQL][ODBC 8.0(w) Driver]Host '<ip address>' is blocked because of many connection error
.

Environment

  • Tableau Cloud
  • Tableau Server
  • Tableau Desktop

Resolution

Option 1:
Make sure the MySQL server is available and health checks are completed.

Option 2:
If the MySQL server is available,  review the following MySQL document*:
caching_sha2_password Compatibility Issues and Solutions

"If your MySQL installation must serve pre-8.0 clients and you encounter compatibility issues after upgrading to MySQL 8.0 or higher, the simplest way to address those issues and restore pre-8.0 compatibility is to reconfigure the server to revert to the previous default authentication plugin (mysql_native_password). "

*Although we make every effort to ensure links to external websites are accurate, up to date, and relevant, Tableau cannot take responsibility for the accuracy or freshness of pages maintained by external providers. Contact the external site for answers to questions regarding its content.

Cause

The errors occur when the MySQL server is not available which can occur when down or restarting.
Did this article resolve the issue?