There are some issues in the instructions for connecitng to MySQL:

http://dba.openoffice.org/FAQ/specific.html#connectmysql

via JDBC: (These steps are only valid for the MySQL connector)
Get the newest JDBC driver from www.mysql.com
Start OpenOffice.org
Goto Tools/Options/Security
press the browse button near "Classpath" and browse for the *.jar file(s) of 
your driver.
Restart OpenOffice.org
Open the data source administration dialog (Tools/Data Sources...)
Press the button "New Data Source", in the name field, enter a valid name like 
"MySQL JDBC", and keep "JDBC" as type.
Enter the data source URL mysql://host:3306/DataabaseName
 
1st thing is that I dont see any Classpath under Tools/Options/Security 
(shouldn't be Java instead)
2nd Tools/Datasources (is this within writer to display the datasources or is 
it Tools/openoffice.org base conections)