CREATE DATABASE IF NOT EXISTS stmms_ft default character set utf8mb4 collate utf8mb4_general_ci;

CREATE  DATABASE college_scan_multi default character set utf8mb4 collate utf8mb4_general_ci;

GRANT ALL PRIVILEGES  ON `stmms_ft`.* TO 'stmms'@'localhost' IDENTIFIED BY 'stmms';

GRANT SELECT ON `stmms_ft`.* TO 'scan'@'%%' IDENTIFIED BY 'scan';

GRANT ALL PRIVILEGES  ON `college_scan_multi`.* TO 'scan'@'%%' IDENTIFIED BY 'scan';

FLUSH  PRIVILEGES;