use mysql;

INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv) VALUES ('${host}', '${zenuser}', PASSWORD('${zenpass}'), 'Y', 'Y', 'Y');

FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `events`;

REVOKE ALL PRIVILEGES ON `events` . * FROM '${zenuser}'@'${host}';

GRANT ALL PRIVILEGES ON `events` . * TO '${zenuser}'@'${host}' WITH GRANT OPTION;

GRANT ALL ON events.* TO '${zenuser}'@'${host}' IDENTIFIED BY '${zenpass}';