Still unable to connect Base to MySQL database (Closed)

[Tonyb2]

Macbook Pro (15 inch 2016)
macOS Big Sur (11.4)
16 GB RAM

LibreOffice
Version: 7.0.6.2
Locale: en-NZ (en_NZ.UTF-8); UI: en-US

Macbook Pro (15 inch 2016)
macOS Big Sur (11.4)
16 GB RAM

LibreOffice
Version: 7.0.6.2
Locale: en-NZ (en_NZ.UTF-8); UI: en-US

Location of Java JDK
/Library/Java/JavaVirtualMachines/jdk-16.0.1/Contents/Home
Oracle Corporation 16.0.1

Connection Pool selections
Driver Name Pool Timeout
com.sun.star.comp.sdbc.mysqlc.MysqlCDriver Yes 68

org.openoffice.drivers.MySQL.Driver Yes 65

Database Wizard

Database name: books2021
Server: localhost
Port number 3306

MySQL JDBC driver class
It does not matter which driver I select in the Connection Pool
The JDBC driver could not be loaded

The database works well using MySQL Workbench

[Ratslinger]

Hello,

Do not have Mac but will attempt to help with my experience on Linux & Windows.

Connection Pool - turn this off as it is not for the driver situation.

As for the needed driver, LO Base come with a native driver for MySQL in the version you are using.

Create a new Base file. On the opening dialog, select Connect to an existing database. Then use the drop down list to select MySQL:

Select Next button and on the next dialog select Connect directly:

Select Next button and on the next dialog enter the name of the MySQL database and provided the server is local use localhost for Server and 3306 for Port.

Select Next button and on the next dialog enter user name used for this database you established and click if password needed. Then you can test connection:

If connection successful, proceed on. Next dialogs are just self explanatory.

This should give you a connection:

[Tonyb2]

@Ratslinger Thank you very much.
The fact that I don’t need the “Connection Pooling” was the answer.

[EarnestAl]

If the answer is correct please click the grey tick next to the answer to turn it green. Cheers, Al