- 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;
|