Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

MariaDB and MySQL Connection

Specifies the options for MariaDB and MySQL databases.

Direct Connection for MariaDB and MySQL databases

Database name

Enter the name of the MariaDB or MySQL database. Ask your database administrator for the correct name.

Server URL

Enter the URL for the database server. This is the name of the machine that runs the MariaDB or MySQL database. You can also replace hostname with the IP address of the server.

Port number

Enter the port number for the database server. Ask your database administrator for the correct port address. The default port number for MySQL or MariaDB databases is 3306.

Named Pipe

If the MariaDB or MySQL database is to be accessed by a named pipe, enter its name.

Socket

If the MariaDB or MySQL database is to be accessed by a socket, enter the socket ID.

Connect using ODBC (Open Database Connectivity)

Connects to an existing ODBC data source that was set on a system level.

Connect using JDBC (Java Database Connectivity)

Connects to an existing JDBC data source that was set on a system level.

The next wizard page depends on your choice of ODBC or JDBC:

ODBC Connection

JDBC Connection

Authentication

Database Wizard