CREATE DATABASE "drupal"
	DEFAULT CHARACTER SET latin1
	DEFAULT COLLATE latin1_swedish_ci;
CREATE DATABASE "jma"
	DEFAULT CHARACTER SET latin1
	DEFAULT COLLATE latin1_swedish_ci;
GRANT USAGE ON *.* TO "drupal_dbo"@'%' IDENTIFIED BY '<password>' ;
GRANT SELECT ON *.* TO "drupal_dbo"@'%' ;
GRANT INSERT ON *.* TO "drupal_dbo"@'%' ;
GRANT UPDATE ON *.* TO "drupal_dbo"@'%' ;
GRANT DELETE ON *.* TO "drupal_dbo"@'%' ;
GRANT ALTER ON *.* TO "drupal_dbo"@'%' ;
GRANT USAGE ON *.* TO "drupal_ro"@'%' IDENTIFIED BY '<password>' ;
GRANT SELECT ON *.* TO "drupal_ro"@'%' ;
GRANT USAGE ON *.* TO "drupal_rw"@'%' IDENTIFIED BY '<password>' ;
GRANT SELECT ON *.* TO "drupal_rw"@'%' ;
GRANT INSERT ON *.* TO "drupal_rw"@'%' ;
GRANT UPDATE ON *.* TO "drupal_rw"@'%' ;
GRANT DELETE ON *.* TO "drupal_rw"@'%' ;
GRANT USAGE ON *.* TO "jma_dbo"@'%' IDENTIFIED BY '<password>' ;
GRANT USAGE ON *.* TO "jma_ro"@'%' IDENTIFIED BY '<password>' ;
GRANT USAGE ON *.* TO "jma_rw"@'%' IDENTIFIED BY '<password>' ;
GRANT USAGE ON *.* TO "monitor"@'localhost' IDENTIFIED BY '<password>' ;
GRANT USAGE ON *.* TO "monitor"@'%' IDENTIFIED BY '<password>' ;
GRANT USAGE ON *.* TO "root"@'localhost' IDENTIFIED BY '<password>'  WITH GRANT OPTION;
GRANT SELECT ON *.* TO "root"@'localhost' ;
GRANT INSERT ON *.* TO "root"@'localhost' ;
GRANT UPDATE ON *.* TO "root"@'localhost' ;
GRANT DELETE ON *.* TO "root"@'localhost' ;
GRANT CREATE ON *.* TO "root"@'localhost' ;
GRANT DROP ON *.* TO "root"@'localhost' ;
GRANT GRANT ON *.* TO "root"@'localhost' ;
GRANT REFERENCES ON *.* TO "root"@'localhost' ;
GRANT INDEX ON *.* TO "root"@'localhost' ;
GRANT ALTER ON *.* TO "root"@'localhost' ;
GRANT RELOAD ON *.* TO "root"@'localhost' ;
GRANT SHUTDOWN ON *.* TO "root"@'localhost' ;
GRANT PROCESS ON *.* TO "root"@'localhost' ;
GRANT FILE ON *.* TO "root"@'localhost' ;
GRANT SHOW DATABASES ON *.* TO "root"@'localhost' ;
GRANT SUPER ON *.* TO "root"@'localhost' ;
GRANT CREATE TEMPORARY TABLES ON *.* TO "root"@'localhost' ;
GRANT LOCK TABLES ON *.* TO "root"@'localhost' ;
GRANT EXECUTE ON *.* TO "root"@'localhost' ;
GRANT REPLICATION SLAVE ON *.* TO "root"@'localhost' ;
GRANT REPLICATION CLIENT ON *.* TO "root"@'localhost' ;
GRANT CREATE VIEW ON *.* TO "root"@'localhost' ;
GRANT SHOW VIEW ON *.* TO "root"@'localhost' ;
GRANT CREATE ROUTINE ON *.* TO "root"@'localhost' ;
GRANT ALTER ROUTINE ON *.* TO "root"@'localhost' ;
GRANT CREATE USER ON *.* TO "root"@'localhost' ;
GRANT TRIGGER ON *.* TO "root"@'localhost' ;
GRANT EVENT ON *.* TO "root"@'localhost' ;
GRANT CREATE TABLESPACE ON *.* TO "root"@'localhost' ;