<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - LO 6.4.6.1 and 7.0.1 fail with error 1045 when accessing MySQL database using native connector" href="https://bugs.documentfoundation.org/show_bug.cgi?id=135202#c37">Comment # 37</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - LO 6.4.6.1 and 7.0.1 fail with error 1045 when accessing MySQL database using native connector" href="https://bugs.documentfoundation.org/show_bug.cgi?id=135202">bug 135202</a> from <a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> Alex Thurgood</a> <pre>(In reply to Dan Lewis from <a href="show_bug.cgi?id=135202#c36">comment #36</a>) > > MySQL(Native) is the connection that I use. I have no idea what you are > asking. Are you referring to the older version of sending the password > (standard authorization)? If so, I created another user using standard > authorization. When connecting to the MySQL database, I got the same error > message. @Dan : (1) Julien's patch only relates to the Windows version of LibreOffice, so if you are using a Linux version, which I believe you are, then the patch will have solved nothing for you. (2) Julien's question to you does indeed refer to the old standard mysql authentication method. However, simply creating a new mysql user and configuring that user account to use the old authentication method won't necessarily work with a mysql server that is configured to use the new authentication method by default. This will very much depend on how you have configured your mysql/mariadb server. The SHA caching plugin problem in general is linked to the lack of implementation for SHA authentication in the libmariadb connector (and possibly also the libariadbclient code, although I haven't check the MariaDB bug repository), which LibreOffice uses to connect to a mysql instance using the native connector. There is additionally, what appears to be path error in recent builds of LibreOffice on all platforms, which attempts to load the SHA caching plugin from a location that does not exist on most users machines. Whether this path error stems from the LibreOffice build platform, or whether it is a fallback search path that is activated due to the lack of SHA caching support in the libmariadb client/connector code is, to me at least, unclear. SHA2 caching support (or rather, the lack thereof) per se is <a class="bz_bug_link bz_status_NEW " title="NEW - Mysql Native Connector - failure to connect to mysql 8 server instance with SHA2 caching" href="show_bug.cgi?id=122560">bug 122560</a>.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>