Connect to MySQL database from LibreOffice Base

Published by

Posted on September 06, 2015

You will need the jdbc class driver which can be installed by following the above link
com.mysql.jdbc.Driver

-Open up any LibreOffice program and then click on Tools->Options.
-Expand LibreOffice option and then click on Advanced.
-Click on the Class Path button on the right followed by Add Archive.
-Browse to /usr/share/java/mysql-connector-java.jar
-Click Ok and choose to restart LibreOffice.
-Now open LibreOffice Base and choose to Connect to an existing database.
-In the drop-down menu choose MySQL, and connect using JDBC.
-Click on the Test class button to make sure the JDBC driver loads successfully. If -it doesn’t, then check that you followed the previous steps properly. If it does load -then simply enter the settings as it relates to your MySQL database.

———————-Fedora 21 ——————-
Yum update JRE
Yum update mysql-connector-java
*then follow the instructions above*

———
This answer was posted on LibreOffice AskBot also .

Categories: Libreoffice