Ask Your Question

Mysql/MariaDB Native Driver for Libreoffice 5? [closed]

asked 2016-02-18 01:26:19 +0100

warehousedatawrangle gravatar image

updated 2020-07-12 18:42:36 +0100

Alex Kemp gravatar image

In the about page on the Libreoffice web site for Base it mentions "native-support drivers for some of the most-widely employed multi-user database engines: MySQL/MariaDB" but the only thing I can find is ODBC/JDBC drivers. Some of the databases I am connecting to are quite large and ODBC/JDBC crashes and is VERY slow. I usually write SQL directly using HeidiSQL, but would like to be able to use a gui for others on my team. Is there a native connection directly to MySQL/MariaDB?

Libreoffice OS- Windows 8.1 - Linux Mint 17.3 MariaDB 10.0.11

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-12 22:31:33.018155


Does "Windows 8.1 - Linux Mint 17.3" mean you have a dual boot system, or is this all on windows OS? I'm also interested if you got this working and if you will please visit this question:

EasyTrieve gravatar imageEasyTrieve ( 2016-10-06 19:18:56 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-02-19 04:35:12 +0100

Steve R. gravatar image

updated 2016-02-19 13:39:58 +0100

Yes, there is a native driver for MySQL, which I assume would work for Maria also.

There should be an extension in Base itself. Look under "tools" -> "extension manager". There should be a native MySQL driver there. A kicker, the native MySQL driver that came with a prior LibreOffice release failed. So I substituted another version "MySQL Connector" that worked and haven't changed it since.

If Base does not have an extension for a native MySQL driver, read through this thread: AOO 4.0 new MySQL native driver 1.2.0 version. The last post in that thread is mine concerning additional extensions. This thread is now "dated" since it is over two years old. In fact, I could not re-locate the web-page containing the extension "MySQL Connector".

Click here for the LibreOffice extensions web-page.

My hope for you is that the current release of LibreOffice (Version 5.1) came with a native MySQL driver under "tools" -> "extension manager". Good luck.

edit flag offensive delete link more

answered 2016-09-29 18:24:04 +0100

AIM gravatar image

Did you ever have any luck? Would like to move to Libre from Open but this native mysql is preventing me.

edit flag offensive delete link more

Question Tools



Asked: 2016-02-18 01:26:19 +0100

Seen: 8,216 times

Last updated: Sep 29 '16