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