How connect to the Mysql from the OpenOffice.org
From FrugalWiki
1. Download the latest version (at 16th Aug 2006 this is version 5.0.3) of the mysql-connector Java driver from: http://dev.mysql.com/downloads/connector/j/
It is a tar.gz compressed file. Create a new folder in /usr. (Example: /usr/mysqlconnector) Open it and copy into the new folder the contents of file.
2. Open OpenOffice.org Calc Then go to Tools ->Settings ->OpenOffice.org -> Java Class path Here you have to give the /usr/mysqlconnector/mysql-connector-java-5.0.3-bin.jar
3.Enjoy the working connection from Ooo DataBase program