Comment 14 for bug 1972820

(In reply to AJ from comment #11)
>
> My understanding is that direct connection just requires installation of
> libreoffice-mysql-connector package.

I have looked through all packages, which are part of LO. There is no package like "libreoffice-mysql-connector" part of the *.deb or *.rpm packages. The connection is included in the package for base.

Could it be you installed an old connector, which worked in versions before LO 6.2? Since LO 6.2 the connector is included and couldn't be separately installed with packages from LO.

When reading about your installation you are using special packages from Ubuntu, not from LO. Please download the packages from
https://www.libreoffice.org/download/download/
and test this packages. You will get an installation like this:
Version: 7.3.1.3 / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Have a look at the Build ID. This is an ID from LO. The Ubuntu packages are packed and combined by Ubuntu, not by LO.