MySQL DB

Install OpenOlat with MySQL

This installation guide is an extension to the general Installation Guide. Replace the database relevant parts with the MySQL counterparts you will find here.

We strongly advice to use Postgres and not MySQL. Postgres will have better performance and stability and it way more tested. We support MySQL because of historic reasons, support might not be guaranteed in the long term.

Set up mysql

If you have any choice, use MySQL 5.6. If you can't, use 5.5. Do not use 5.1, there are many issues with 5.1.

User and DB

Do the following as mysql root user (you may need the mysql root password):

mysql -u root -p

and do this:

create database oodb character set utf8 collate utf8_unicode_ci;
create user oodbu@localhost identified by 'oodbpasswd';
grant all on oodb.* to oodbu@localhost;

Test DB access

Test the mysql account as openolat user

mysql oodb -u oodbu -poodbpasswd

You should get the mysql cli prompt.

Exit

Create DB schema

Create the OpenOLAT database schema

cd /home/openolat/webapp/WEB-INF/classes/database/mysql/
mysql oodb -u oodbu -poodbpasswd < setupDatabase.sql

Optionally

Create a file named .my.cnf containing

[client]
database=oodb
user=oodbu
password=oodbpasswd

then you can access the database by just typing mysql.