Prepare the Database on Windows

The LogicalDOC's installer also includes a MariaDB and will use it by default, but if you want to connect LogicalDOC to an existing MySQL or MariaDB installation this guide describes how to prepare the database where the application will store all data. The MySQL(currently we recommend MySQL 8) package and its installation instructions for your system are available here: www.mysql.com

We also provide a video guide for the installation of MySQL - Watch the video on Youtube

Default settings

LogicalDOC requires you to configure your MySQL installation to best fit the needs of a professional DMS.

Supposing that your MySQL data folder is C:\ProgramData\MySQL\MySQL Server 8.0 open the configuration filemy.ini, find the [mysqld] section and put the following settings and make sure to have the following settings in the [mysql] and [mysqld] sections:

[mysql]
default-character-set = utf8

[mysqld]
character-set-server = utf8
collation-server = utf8_bin
default-storage-engine = INNODB

This sets the encoding to UTF-8 and the default storage engine to the INNODB with transactions support.

After the editing, restart the MySQL service.

Creating the database

Connect to mysql prompt by typing the command:

$ "C:\Program Files\MySQL\bin\mysql.exe" -u root -ppassword

Execute the following command at the mysql prompt:

CREATE DATABASE logicaldoc;

Now we have an empty database called logicaldoc with a user root that can access it using password password.
You can exit the mysql prompt(command \q) and go ahead.