Regresar
-
Título
Get "Authentication plugin 'caching_sha2_password' cannot be loaded" error running Cross Connection query -
Descripción
When running a cross connection query, which includes a MySQL 8 database, the following error is returned."ODBC data source returned an error: Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found." -
Causa
They are 2 defects causing this issue and preventing a workaround with the MySQL connection type.1. The MySQL ODBC v5.3 driver, installed by default by TDP, doesn’t support the 'caching_sha2_password' feature.2. Even if the MySQL ODBC v8.0 driver, which supports 'caching_sha2_password', is downloaded and the user selects the v8.0 ODBC driver in TDP's MySQL connection Advanced tab, TDP will still use the default ODBC driver(v5.3) to do a cross connection query. -
Resolución
WORKAROUND #1:Change the authentication from the caching_sha2_password method to the sha256_password method.WORKAROUND #2:1) Install a MySQL v8.0 ODBC driver, which can be downloaded here.2) Create a User or System DSN in the Windows ODBC Driver Manager window with MySQL v8.0 ODBC driver.3) Create a new connection in TDP, to connect to your MySQL database, using the 'ODBC Generic Connection' option, instead of MySQL. Use the DSN you created when setting up this ODBC Generic connection.4) Connect with the ODBC Generic connection, instead of with your MySQL connection, and you will be able to run the Cross Connection query.STATUS:Waiting for a fix to be released in a future version of Toad Data Point. -
ID de defecto
TMB-3578