[patch] net-analyzer/zenoss/files/mysql-setup.sql

mysql-setup.sql (text/plain), 452 bytes, created by mikael lammentausta on 2006-12-14 08:14:40 UTC

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}';