Quick Metron DB setup

mysql.sql

CREATE DATABASE IF NOT EXISTS metron;

GRANT ALL PRIVILEGES ON metron.* TO 'metron'@'sball-metron-0.field.hortonworks.com' identified by 'metron';

use metron;

create table if not exists users(
 username varchar(50) not null primary key,
 password varchar(50) not null,
 enabled boolean not null
);
create table authorities (
 username varchar(50) not null,
 authority varchar(50) not null,
 constraint fk_authorities_users foreign key(username) references
 users(username)
);
create unique index ix_auth_username on authorities (username,authority);

insert into users (username, password, enabled) values ('admin', 'admin',1);
insert into authorities (username, authority) values ('admin', 'ROLE_USER');


CREATE DATABASE IF NOT EXISTS druid;
CREATE DATABASE IF NOT EXISTS superset;
ALTER DATABASE druid CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER DATABASE superset CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON druid.* TO 'druid'@'%' identified by 'druid';
GRANT ALL PRIVILEGES ON superset.* TO 'superset'@'%' identified by 'druid';

FLUSH PRIVILEGES;