Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You don't need JDK - JRE is fine but I would think about upgrading to version 8.

I have been using the MySQL JDBC connector(with MySQL) for quite some time now and have had no problems. This page (click here) contains instructions for connection of Base and MySQL and a link to the JDBC connector. The Class Path is discussed but is nothing more than pointing to (using Add Archive) the connector .jar file.

Once installed you create a new Base file selecting Connect to an existing database and select MySQL. This is where you enter the connection properties:

image description

And

image description

If all entered OK, you're up and running.

You don't need JDK - JRE is fine but I would think about upgrading to version 8.

I have been using the MySQL JDBC connector(with MySQL) for quite some time now and have had no problems. This page (click here) contains instructions for connection of Base and MySQL and a link to the JDBC connector. The Class Path is discussed but is nothing more than pointing to (using Add Archive) the connector .jar file.

Once installed you create a new Base file selecting Connect to an existing database and select MySQL. This is where you enter the connection properties:

image description

And

image description

If all entered OK, you're up and running.

Edit: 2/4/17

Although subtle, there seems to be some differences between MariaDB and MySQL. I attempted to perform an installation based upon the instructions presented by @EasyTrieve with the following results:

Start with almost newly installed OS of Debian 8.6 using Cinnamon v2.2.16 (almost because a few months back I installed LO v5.2.3.3). Using Synaptic Package Manager, installed MariaDB-server and all recommended affliates. During the installation part, you will be asked for a password (for root account).

Signing on was a bit of a pain - mentioned instructions were overly stated. You just need mysql -u root -p for first time sign-in. Then prompted for password from the installation step. Signed in so listed databases:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+

Not even the "test" database stated in the instructions here. Luckily the next page of instructions provided the creation of a DB & some tables here. show tables; and show databases; proved they were created.

LO , as mentioned, was installed. Moved over JRE 8u102 from Mint 18 and pointed to it in LO. Downloaded mariadb-java-client-1.5.7.jar - it would not work no matter what was done. Tried to get v1.5.3 but they wanted a sign in. Signed up but even when asking to v1.5.3 only 1.5.7 was offered.

Copied MySQL connector from Mint 18 - Connector/J 5.1.36, localhost:3306 & my "test" DB and connection worked immediately.

Then tested with JDBC directly and confirmed "Relationship" problem.

NOTE: Connect directly is gone if MariaDB is installed (even in LO v5.2.3.3) but not if MySQL is installed (there in my Mint 18 OS w/LO v5.3.0.3).

You don't need JDK - JRE is fine but I would think about upgrading to version 8.

I have been using the MySQL JDBC connector(with MySQL) for quite some time now and have had no problems. This page (click here) contains instructions for connection of Base and MySQL and a link to the JDBC connector. The Class Path is discussed but is nothing more than pointing to (using Add Archive) the connector .jar file.

Once installed you create a new Base file selecting Connect to an existing database and select MySQL. This is where you enter the connection properties:

image description

And

image description

If all entered OK, you're up and running.

Edit: 2/4/17

Although subtle, there seems to be some differences between MariaDB and MySQL. I attempted to perform an installation based upon the instructions presented by @EasyTrieve with the following results:

Start with almost newly installed OS of Debian 8.6 using Cinnamon v2.2.16 (almost because a few months back I installed LO v5.2.3.3). Using Synaptic Package Manager, installed MariaDB-server and all recommended affliates. During the installation part, you will be asked for a password (for root account).

Signing on was a bit of a pain - mentioned instructions were overly stated. You just need mysql -u root -p for first time sign-in. Then prompted for password from the installation step. Signed in so listed databases:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+

Not even the "test" database stated in the instructions here. Luckily the next page of instructions provided the creation of a DB & some tables here. show tables; and show databases; proved they were created.

LO , as mentioned, was installed. Moved over JRE 8u102 from Mint 18 and pointed to it in LO. Downloaded mariadb-java-client-1.5.7.jar - it would not work no matter what was done. Tried to get v1.5.3 but they wanted a sign in. Signed up but even when asking to v1.5.3 only 1.5.7 was offered.

Copied MySQL connector from Mint 18 - Connector/J 5.1.36, localhost:3306 & my "test" DB and connection worked immediately.

Then tested with JDBC directly and confirmed "Relationship" problem.

NOTE: Connect directly is gone if MariaDB is installed (even in LO v5.2.3.3) but not if MySQL is installed (there in my Mint 18 OS w/LO v5.3.0.3).