hetzner/db/mariadb_simple/init.sql

CREATE DATABASE IF NOT EXISTS dr_mustikas
  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS dr_see1
  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS dr_merbond
  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS ojs_acta
  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS wp_nuudi
  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS dr_kaie
  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS dr_bussikeskus
  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS dr_test9
  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE USER IF NOT EXISTS 'user'@'%'
  IDENTIFIED BY PASSWORD '*4286C2189656155D2C4DFE0216D0186BCCB25824';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTION;

CREATE USER IF NOT EXISTS 'dr_mustikas'@'%'
  IDENTIFIED BY PASSWORD '*BAB0FFDC26C46E0006D98D6AE9C6F3F06E8348DD';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
  CREATE TEMPORARY TABLES, LOCK TABLES ON dr_mustikas.* TO 'dr_mustikas'@'%';

CREATE USER IF NOT EXISTS 'dr_merbond'@'%'
  IDENTIFIED BY PASSWORD '*408ED883AD85EEBED26085B86DBF18D416A3D98F';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
  CREATE TEMPORARY TABLES, LOCK TABLES ON dr_merbond.* TO 'dr_merbond'@'%';

CREATE USER IF NOT EXISTS 'dr_see1'@'%'
  IDENTIFIED BY PASSWORD '*519679367F136081079A40CCE600BDE099D86612';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
  CREATE TEMPORARY TABLES, LOCK TABLES ON dr_see1.* TO 'dr_see1'@'%';

CREATE USER IF NOT EXISTS 'dr_kaie'@'%'
  IDENTIFIED BY PASSWORD '*0B637EDD1560AB519DE6D3AD181BAAAB662F9890';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
  CREATE TEMPORARY TABLES, LOCK TABLES ON dr_kaie.* TO 'dr_kaie'@'%';

CREATE USER IF NOT EXISTS 'dr_bussikeskus'@'%'
  IDENTIFIED BY PASSWORD '*0B637EDD1560AB519DE6D3AD181BAAAB662F9890';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
  CREATE TEMPORARY TABLES, LOCK TABLES ON dr_bussikeskus.* TO 'dr_bussikeskus'@'%';

CREATE USER IF NOT EXISTS 'dr_test9'@'%'
  IDENTIFIED BY PASSWORD '*61EC257D9C5D3E23C9362856C530ADD843A0BACE';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
  CREATE TEMPORARY TABLES, LOCK TABLES ON dr_test9.* TO 'dr_test9'@'%';

CREATE USER IF NOT EXISTS 'wp_nuudi'@'%'
  IDENTIFIED BY PASSWORD '*8D72AD81EF30B6091B3D8EE1603D1EE02F4A2C85';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
  CREATE TEMPORARY TABLES, LOCK TABLES ON wp_nuudi.* TO 'wp_nuudi'@'%';

CREATE USER IF NOT EXISTS 'ojs_acta'@'%'
  IDENTIFIED BY PASSWORD '*7934F7DD176B90395C27530BB4D427A633F94936';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER,
  CREATE VIEW, SHOW VIEW, TRIGGER ON ojs_acta.* TO 'ojs_acta'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;