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.
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:
default-character-set = utf8
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.
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
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."