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

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.