<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Mysql Native Connector - failure to connect to mysql 8 server instance with SHA2 caching" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122560#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Mysql Native Connector - failure to connect to mysql 8 server instance with SHA2 caching" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122560">bug 122560</a> from <a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> Alex Thurgood</a> <pre>(In reply to Alex Thurgood from <a href="show_bug.cgi?id=122560#c0">comment #0</a>) > Description: > The latest release of mysql community server implements SHA2 caching for > passwordk encryption when connecting to the server. > > This is not supported by the libmysqlconnector. > > Attempting to create an ODB file connecting directly to a 8.0 mysql server > using SHA2 caching leads to the error : > > Statut SQL: HY000 > Code d'erreur: 2058 > > Plugin caching_sha2_password could not be loaded: > > The ODB file can not be created. > > > Steps to Reproduce: > 1. Try to create an ODB file connecting directly to a 8.0 mysql server > instance that uses SHA2 caching for password management (default setting on > 8.x servers) > > 2. Enter IP address, user name and click on password required box in the > relevant dialogs using the wizard. > > 3. Click on Test connection. Enter the user password. > > 4) Error message : Statut SQL: HY000 > Code d'erreur: 2058 > > Plugin caching_sha2_password could not be loaded: > > 5) No ODB file can be created. > Actually, point 5 above is incorrect, the file can be createdby ignoring the test, clicking on Next and saving the ODB file, but no connection to the server will ever be established to read the databases/tables when that ODB file is reloaded into LO.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>