[Libreoffice-bugs] [Bug 135793] New: LO 7 and 6.4.6 cannot connect to MySQL database

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 135793
           Summary: LO 7 and 6.4.6 cannot connect to MySQL database
           Product: LibreOffice
           Version: 7.0.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: iesaridakis at gmail.com

Description:
In Lo 7.0.0.3, connecting to a local MySQL database, which I've been using for
years with LO fails with the following error, after providing the login
credentials:
"The connection to the data source %DB_name could not be established. Plugin
mysql_native_password could ne be loaded:
/home/buildslave/-source/libo-core/connectivity/source/drivers/mysql/mysqlc_general:cxx:-119".
Also, when trying to connect using LO 6.4.6, produces the following error: "The
connection to the data source %DB_name could not be established. Plugin
mysql_native_password could not be loaded".
In LO 6.3.6.2, everything works as expected.
Also, connecting to the MySQl db is possible, through http and phpmyadmin.
I've changed MySQL's authentication method to SHA256 and sha2, or the db
connection from localhost to 127.0.0.1 and vice-versa, but to no avail.

Actual Results:
Impossible to connect to the MySQL database

Expected Results:
Connect to and interact with the MySQL database


Reproducible: Always


User Profile Reset: Yes



Additional Info:
System details:
Linux Mint 20
libreoffice-sdbc-mysql, libreoffice-mysql-connector: 1:6.4.4.-0
mysql-server, mysql-connector-java (and -odbc): 8.0.21

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200816/ee139ebe/attachment.htm>