How to connect libreoffice base to a remote mysql database. Apache openoffice base base is a fully featured desktop database management system, designed to meet the needs of a broad array of users, from tracking a personal cd collections, to producing a corporate monthly departmental sales reports. The mysql sdbc driver for apache openoffice installs a native mysql database driver. The following example demonstrates the creation of a new base database which uses a local mysql server for storage and the new connector for. It is faster, seamless integrated, easier to administrate and there is no need to install and setup a jdbc or odbc driver separately. This document is a not manual on how to write a driver, but how to put it in an openoffice. There are drivers for postgresql, sqlite and msaccess mdb files. Create new database tables or use the powerful sql query editor of. The mysql native connector provides a native mysql database driver for libreoffice 4. Frequently asked questions base the document foundation wiki.
Lets say that our driver implements the following services. The postgresql sdbc driver allows to use the postgresql database from openoffice. Databasedriversmysql nativeoverview apache openoffice. Select connectorj from the mysql connectors section of the web page. You can use an odbc driver, the jdbc driver, or install the mysql connector extension.
Connecting openoffice and libreoffice to mysql via odbc driver. Note that you will need to have first created your database on your mysql server. Solved using mysql with base view topic apache openoffice community forum. It was never easier to use mysql databases in libreoffice base. Databasedriversnew driver tutorial apache openoffice wiki. Also you can check an expanded list of odbc drivers for oracle, sql server, postgresql, mysql, sqlite postgresql 3. The apache openoffice user forum is an user to user help and discussion forum for exchanging information and tips with other users of apache openoffice, the open source office suite. You can access mysql data from open office base or libreoffice base desktop database management systems. This is a tutorial on connecting to a mysql database server with base using the jdbc connector. Mysql driver for apache openoffice apache openoffice.