Connect MySQL and Base

Here is a tutorial to connect MySQL database with OpenOffice.org Base.

Using JDBC on Linux

OpenOffice.org comes directly with support of JDBC connectivity to multiple databases. OpenOffice.org needs Java Runtime Environment to be able to use JDBC. Verify that you have JRE on your OOo by going to Tools - Options - OpenOffice.org General - Java.

Next step is to download the mysql-connector-J which you can download from the MySQL website. MySQL Connector/J adds JDBC connectivity to MySQL. Once you have this setup we can go into OpenOffice.org and follow the process.

You can also use the corresponding packages of your distribution like

• libmysql-java for debian and ubuntu

Using ODBC on Linux

OpenOffice.org also support ODBC connectivity to MySQL, you will need Unix-ODBC in order to make a connection through it.

Recommendations settings

Known issues regarding MySQL and OpenOffice.org can be avoided by having specific settings here are some of those:

MySQL settings

• Make sure that MySQL is using TCP/IP as opposed to sockets. Edit the my.cnf file at /etc/ and comment skip-networking

OpenOffice.org settings

• OpenOffice.org uses Java for JDBC, please make sure you have JRE at Tools - Options - OpenOffice.org General - Java
• Declare the mysql-connector-j.bin at the classpath at Tools - Options - OpenOFfice.org General - Java