Prepare the Database on macOS

In order to setup a production system you have to prepare a MySQL database where the application will store all data.
To perform this step, make sure to have a MySQL up and running, if this is not the case install it: http://dev.mysql.com/downloads/mysql/

Once your MySQL instance is up and running, please open a terminal and execute this command:

$ sudo su

Type your password as requested in order to login as the root user.

Default settings

LogicalDOC requires you to configure your MySQL installation to best fit the needs of a professional DMS, so we need to create the file /etc/my.cnf in this way:

$ cd /usr/local/mysql/support-files/
$ cp my-medium.cnf /etc/my.cnf

Now edit your current my.cnf configuration file, 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.

Setting Password for MySQL Root User

Execute the following commands at a shell prompt:

$ /usr/local/mysql/bin/mysqladmin -u root password 'password'

Creating the database

Connect to mysql prompt typing the command:

$ /usr/local/mysql/mysql -u root -ppassword

Execute the following commands 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.

Post-installation

OS X uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL.
But sometimes the installation process can go wrong or perhaps you run anĀ upgrade of your Mac and MySQL will not start at boot...
To fix this problem you just need to add a special fileĀ into your /Library/LaunchDaemons directory, so please refer to the Oracle's MySQL reference manual to better understand the procedure:

MySQL 5.5 https://dev.mysql.com/doc/refman/5.5/en/osx-installation-launchd.html
MySQL 5.6 https://dev.mysql.com/doc/refman/5.6/en/osx-installation-launchd.html
MySQL 5.7 https://dev.mysql.com/doc/refman/5.7/en/osx-installation-launchd.html

Attention

Directories and executable files inside the StartupItems and LaunchDaemons folder should have permissions of 0755 with the owner set to "root" and group set to "wheel." Other (non-executable) files should have permissions of 0644 with the owner set to "root" and group set to "wheel."