MariaDB

Applies to Collaborator 14.9, last modified on October 14, 2025

MariaDB Server is one of the most popular open-source relational databases. It's made by the original developers of MySQL and guaranteed to stay open source.

Supported MariaDB Versions

Collaborator supports MariaDB versions 10.6.x, 10.11.x and 11.4.x

Note: MariaDB database is supported in Collaborator Team and Collaborator Enterprise. For a complete list of differences between Collaborator editions, see the comparison page.

Download MariaDB Components

Required components

Optional components

  • HEIDISQL – Is a powerful, free (gpl) software only available for Windows, that is part of the category Development software with subcategory Database and has been created by Heidisql.

For downloads and documentation for all platforms, see the MariaDB database documentation website.

Install and Configure Database

First, install the database server component. Once you have installed the server, the last screen will give you the option to configure the MariaDB server. If you select this, it will open a new wizard for configuration. Two parts in the configuration that are especially important: Port Number and Root Password. You will need to know both while getting your database setup and while configuring Collaborator to work with your database. For information on configuring your database server, go to the MariaDB database documentation

Notes:
  • In MariaDB, InnoDB is the default and generally preferred storage engine for its transactional capabilities, row-level locking, and ACID compliance, while MyISAM is an older, non-transactional engine better suited for read-heavy, non-critical applications. Maria database tables, see https://phoenixnap.com/kb/myisam-vs-innodb
  • Collaborator does not support the non-default values of the auto_increment_increment and auto_increment_offset MariaDB system variables.

For Collaborator, you have to create a separate database, since the MariaDB Server install will not create a database for you. This is a manual step that you need to do.

You can create a database using the MariaDB Command Line Client, or using HEIDISQL. The instructions given in this documentation use the functionality in the current GUI client, HEIDISQL.

The steps below for creating a database were written using HEIDISQL 12.8.0.6908 and are subject to change. As always, the most reliable source for database creation steps is MariaDB HeidiSQL Documentation

  1. Launch HEIDISQL.

  2. Click on New to create a new session if you haven't configured one already.

  3. Enter the Hostname / IP (e.g., localhost or 127.0.0.1).

  4. Enter the Username (default: root).

  5. Enter the Password (if set).

  6. Click Port (default: 3306).

  7. Click Open to connect

  8. In the left-side panel, right-click on the server name or an existing database.

  9. Select Create new --> Database .

  10. Enter a database name (e.g., mydatabase).

  11. Choose the Collation (e.g., utf8mb4_general_ci for full UTF-8 support).

  12. Click OK to create the database.

We recommend that you create a user specifically for your Collaborator database rather than using the super-user, root. The database user must have the following priveleges: ALTER, CREATE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EXECUTE, INDEX, INSERT, LOCK TABLES, SELECT, UPDATE.

All of these changes go into effect immediately. You do not have to restart the MariaDB server for changes to take effect.

Note: For installing collaborator with Mariadb use mysql wizard. (Refer MySQL installation steps here installing)

See Also

Server Installation Steps
Backup and Migration
Database Installation

Highlight search results