Re: Bug 122675 MySQL native connector problem with LO 6.2.0.2

also from the MySQL documentation there is the option to reconfigure the
server to use the older default authentication:
"Further, it is always possible to change ––default-authentication-plugin
to a non-default value of your choice (At present, options other than
caching_sha2_password are: mysql_native_password and sha256_password). For
example, if ––default-authentication-plugin is set to
mysql_native_password, the behavior of the MySQL 8.0.4 server is similar to
MySQL 8.0.3 and prior. Correspondingly, libmysqlclient supports the
MYSQL_DEFAULT_AUTH options for mysql_options() C API function. (For
libmysqlclient based client tools available in MySQL packages, the
––default-auth command-line options achieves the same purpose.) The
client-side option is a performance tool and saves an extra round-trip when
used in tandem with ––default-authentication-plugin option on server side.
However, we recommend use of caching_sha2_password because of the enhanced
security that it offers. We also recommend updating libmysqlclient to MySQL
8.0.4 or later so that new default authentication plugin is supported by
clients that use it."

https://mysqlserverteam.com/mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password/

On Sat, Jan 12, 2019 at 1:11 PM Drew Jensen <drewjensen.inbox@gmail.com>
wrote:

> Howdy Dan,
>
> Some information on the problem and work around can be found here:
> https://tableplus.io/blog/2018/07/failed-to-load-caching-sha2-password-authentication-plugin-solved.html
>
> The issue was opened by another person yesterday and this issue was lined
> to it.
>
> Drew
>
> On Sat, Jan 12, 2019 at 12:23 PM Dan Lewis <elderdanlewis@gmail.com>
> wrote:
>
> > I get the following error message when using the Base Wizard in LO
> > 6.2.0.2 to connect to a MySQL database.
> >
> >            Can't initialize character set unknown (path: compiled_in)
> >
> > I get as far as clicking the the Test Connection button. When entering
> > the password and clicking OK, I get this message. I have MySQL 8.0.13
> > for my back end. I set up to use SHA2 with my password. (This may well
> > be the where the problems lie.)
> >
> > Dan
> >
> > _______________________________________________
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice