Skip to main content

Prepare the Database on Ubuntu

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 edit the file /etc/my.cnf in this way:

$ viĀ /etc/mysql/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 command at a shell prompt:

$ mysqladmin -u root password 'password'

Creating the database

Connect to mysql prompt typing the command:

$ mysql -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.

http://dev.mysql.com/doc/refman/5.1/en/macosx-installation.html