There are two ways to create your OLAT MySQL database:
Use the script /olat3/bin/dbAndUserSetup.sh to automatically generate the OLAT database and user. You will be prompted to enter the mysql root password.
Or, create the database and user manually, and setup the database.
# mysql -u root -p On the console run the following SQL-statements: # use mysql; # mysql> create database olat; # mysql> create user 'olat'@'localhost' identified by 'olat'; # mysql> grant all on olat.* to 'olat'@'localhost' identified by 'olat'; # mysql> flush privileges; # mysql> source OLAT3_HOME/webapp/WEB-INF/src/resources/database/mysql/setupDatabase.sql;