Skip to main content
Version: 5.0.1.0

MariaDB

Adaption of MariaDB configuration​

To configure your database to run Solution Hub, you need to change the MariaDB configurations. To do so, open the my.ini or my.cnf (e.g. in /etc/mariadb or C:\Programme\MariaDB\MariaDB Server X.X) in a text editor and change the settings as shown below.

[client]
default-character-set=latin1

[mysqld]
collation-server = latin1_german1_ci
init-connect='SET NAMES latin1'
character-set-server = latin1
wait_timeout = 28800
transaction-isolation=READ-COMMITTED
lower_case_table_names = 1
max_allowed_packet = 100M 
default-storage-engine=INNODB

Restart the MariaDB server afterward. This can be done in the MariaDB console, the MariaDB System Tray Monitor or directly in Control Panel>Administrative Tools>Services.

Parameters can be displayed on the console with the SQL statement: sql SHOW VARIABLES like 'lower%';

Creation of the database​

  1. Start the MariaDB console as root

    mariadb -h localhost -u root –p

  2. Create a database

    CREATE DATABASE SOLUTIONHUB;

  3. Create a user for the database

    warning

    The password of the SOLUTIONHUB database user should be changed for security reasons!

    CREATE USER SOLUTIONHUB@localhost IDENTIFIED BY SOLUTIONHUB;

  4. Grant all rights of the database to the user

    GRANT ALL PRIVILEGES ON SOLUTIONHUB.* TO SOLUTIONHUB@localhost;

  5. Log out as root

    \q

  6. Set up the database by following the steps described in Flyway database setup