Database/Drivers/MySQL Native/Beta

From Apache OpenOffice Wiki
< Database‎ | Drivers‎ | MySQL Native
Revision as of 13:36, 9 April 2009 by Nixnutz (Talk | contribs)

Jump to: navigation, search


MySQL Connector/ is a MySQL driver for It can be used to connect from 3.1 to a MySQL server 5.1 or newer.

Before MySQL Connector/ became available you'd have to use MySQL Connector/J (JDBC) or MySQL Connector/ODBC to connect to a MySQL server.

Therefore the driver is also referred to as a native driver in the context of The term native driver clashes with the MySQL definition of a native driver. MySQL Connector/ does not implement the MySQL Client Server protocol. Technically speaking the MySQL Connector/ is implemented as a proxy on top of the MySQL Connector/C++.

The driver is delivered as an extension.


Using MySQL Connector/ has the following advantages:

  • Easy installation through the Extension Manager.
  • Seamless integration into
  • No need to go through an additional Connector installation routine (ODBC/JDBC)
  • No need to configure or register an additional Connector (ODBC)
  • No need to install or configure a driver manager (ODBC)


Please note, the MySQL Connector/ is released as an alpha version. We do not recommend using the driver in production environments or systems with critical data. Please note, official support is not available.


Install or upgrade to 3.1 3.1 is available as a Release Candidate at The driver does not work together with any other version.

Caution: The installation wizard of 3.1 will remove older installations from your system by default. If you wo not want this, check out for the corresponding settings of the installation wizard.

Download MySQL Connector/

The alpha version is available as a QA build from -

The extension is available for the following platforms:

Save the download to a location of your choice, for example My Documents or ~/Documents.

Installing the extension

Add the .oxt extension through the Extension Manager of In, select Tools, Extension Manager... and specify the .oxt file as a new extension. When done, MySQL Connector/ should show up as a new extension under My Extensions.

File:Conn ooo alpha extensions.jpg

Restart to complete the installation.

Getting Started: Connecting to MySQL

MySQL Connector/ allows you to access the MySQL Server and its schemata from the suite.

The following example demonstrates the creation of a new Base database which uses a local MySQL Server for storage and the new connector for connecting.

Select the database

Create a new database (File, New, Database). This starts a wizard that allows you to create a new, open an existing, or connect to existing database. Select the latter option.

From the drop-down list, select MySQL. Click Next >>.

File:Conn ooo alpha wizard1.jpg

Select the type of the driver

You can use three different MySQL drivers for connecting to MySQL from You can choose a generic ODBC or JDBC connection method or the native driver. Select Connect native. Click Next >>.

File:Conn ooo alpha wizard2.jpg

Setting up the database connection

Set up the database connection. Put the schema (database) you want to connect to into Name of the database. Enter the URL (host name), Port and Socket of your MySQL Server. Click Next >>.

File:Conn ooo alpha wizard3.jpg

Fill in user credentials

Provide the user credentials for connecting to your MySQL Server. Click Next >>.

File:Conn ooo alpha wizard4.jpg

Save and proceed

Finish the wizard. All defaults are a safe choice. Click Finish >>.

File:Conn ooo alpha wizard5.jpg

Getting Started: Usage Examples

Listing Tables

In the Database area of the Base main window, select Tables. If this is the first time you're accessing the database you'll be prompted for your credentials (username and password); you can store these settings for your current Base session.

File:Conn ooo alpha base.jpg

Depending on your connection settings you will now see all databases with all their tables, or just the database you've specified in the connection settings.


See the website for documentation of the office suite and its Extension Manager.

Known Bugs

If you discover a bug in Connector/ please add it to this list and send an email to You need to be logged in with an account for both; see for details.


To discuss the new MySQL Connector/, please subscribe to the mailing list It is a low-volume list with less than 10 mails per day.

Personal tools