REM-Mod

Table of Contents

2.3) Setup MariaDB

2.3) Setup MariaDB

Create new connection parameters to a MariaDB server:

File --> Connection Manager --> Settings

When you click the "New" button on the left bottom corner, you should be prompted to provide the details for the new connection.

Type following setting entries on the right side:

Hostname / IP: 127.0.0.1
Username: root
Password = yourpassword0
Port: 3306

Click on the left bottom corner the "Save" button and on the right bottom corner on the "Open" button.

Next step is to include the database (sql file). Click on:

File --> Load SQL File

If this doesn't work click on:

File --> Execute SQL File

You have to ask the Admins for the database SQL file. This file is not attached on this post.

Press F5 to refresh your DB overview

Also check your server configuration in the following path:

Open my.ini in the folder C:\Program Files\MariaDB 11.6\data

It should look something like that. Sometimes the line ssl=off are missing.

[mysqld]
datadir=C:/Program Files/MariaDB 11.6/data
port=3306
ssl=off
innodb_buffer_pool_size=6030M
[client]
port=3306
plugin-dir=C:\Program Files\MariaDB 11.6/lib/plugin

https://i.imgur.com/UHcLMmh.png