connecting directly to MySQL

I use LO 6.3.2.1 and MySQL Connector/J to connect to my MySQL database with no problem. My authentication method is Standard which is what MySQL used for their 5.x servers and clients.

However, I am not able to connect directly to my MySQL database. For this, I have installed a second instance of LO 6.3.2.1 following the instructions contained on the LO website. Furthermore, I modify the bootstraprc file so it points to a new configuration folder (Direct). When I first run this instance of LO, it creates a new folder in .config/libreoffice/. (I use Ubuntu 18.04.) I open the Base Wizard and select MySQL to connect to my database directly (two steps). I enter the database info and click Test Connection. I get an error message: can't initialize character set unknown (path: compiled_in). As others seem to be able to connect directly (I think), is it possible that my failure to do so is caused by my selection of Standard as my authentication method? Should I change this to the method introduced with the first MySQL 8.0.x? Or, could there be another explanation?

Dan

Hi Dan,

Probably this bug :

https://bugs.documentfoundation.org/show_bug.cgi?id=122560

Which comes from the LO project using an old version of the mariadb C
connector library code to build the connector.

Alex

Hi Dan,

Probably this bug :

https://bugs.documentfoundation.org/show_bug.cgi?id=122560

Which comes from the LO project using an old version of the mariadb C
connector library code to build the connector.

Alex