mariadb

Preparing the mariadb database

CREATE USER 'ossecuser'@'OSSEC-IP' IDENTIFIED BY 'PASSWORD';

GRANT INSERT,SELECT,UPDATE,CREATE,DELETE,EXECUTE on ossec.* to ossecuser@'OSSEC-IP';

flush priviledges;

Loading the ossec schema

$ mysql -u ossecuser -p ossec < mysql.schema