Go to MySQL Connector for the installation and use of the MySQL database connector.

To test whether you can connect to MySQL, click the Tables tab.

To ensure your parameters are recorded, press the 'Apply' button.

Now you enter the username and, if you have a password, mark the checkbox.

If you use some other driver you should refer to your manual for the correct name of the driver.

Enter the URL of the MySQL server, for example mysql://localhost/DatabaseName.

Press the button 'New Database' and enter a valid name like MySQLJDBD and set the type to JDBC.

Under 'Utils > Data sources' over the database administration dialogue box.

Here choose 'Security' and press the 'Add' button to the *.jar files for your driver.

Start LibreOffice and open the dialogue box 'Options' under 'Utils > Options'.

Get the new JDBC driver from (or your distribution repository).

The following steps are only valid for a MySQL connection. You can get a first glimpse of the driver on the site unixODBC in the documentation section. You can use an ODBC driver, the JDBC driver, or install the MySQL Connector extension. At this point there are three possibilities.

Please refer to the MySQL specifications page ,įirst of all you have to decide which driver you are going to use. But, unless you use the MySQL connector extension (see below), you always have to know what type of connection you want to use. We have just introduced a new, addtional for MySQL.

Libreoffice mysql