CREATE DATABASE kidows;

CREATE USER 'ukidows'@'%' IDENTIFIED BY 'sycamore';
GRANT SELECT, INSERT, UPDATE, DELETE, FILE ON *.* TO 'ukidows'@'%';

CREATE USER 'rc_kidows'@'%' IDENTIFIED BY '321military';
GRANT SELECT, INSERT, UPDATE, DELETE, FILE ON *.* TO 'rc_kidows'@'%';

CREATE USER 'web'@'%' IDENTIFIED BY 'neb9604';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE ON *.* TO 'web'@'%';
