I have KDE Neon (updated with Kubuntu 20.04.01), which provides LO only 6.4, so I installed (in /opt) LO 7, not replacing, but adding to 6.4.
I’d like to have a direct mysql connection, but I noticed that mysql-connector provided with Ubuntu is not working with LO 7 in /opt.
And with the extension downloaded as extension there are problems.
How should I do to get mysql direct connect in LO 7 in /opt?
Eventually I installed LO 7 via PPA, after removing LO in /opt. But I have still a connection problem, in odb files mysql-related, so to say: I get this error:
Can't connect to MySQL server on 'localhost' (111) /build/libreoffice-ron9it/libreoffice-7.0.0~rc3/connectivity/source/drivers/mysqlc/mysqlc_general.cxx:119
I noticed that this problem is not only in LO 7, but also in LO 6.4.
The last time that mysql-connector provided with Ubuntu worked correctly, was with the 6.0 version, before updating to Ubuntu 20.04.