데이터 베이스

CREATE DATABASE IF NOT EXISTS msa CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

GRANT ALL PRIVILEGES ON msa.* TO 'msa'@'localhost';

FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS msa2 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

GRANT ALL PRIVILEGES ON msa2.* TO 'msa'@'localhost';

FLUSH PRIVILEGES;

• User Setting

CREATE USER IF NOT EXISTS 'msa'@'localhost' IDENTIFIED BY '123';

- Gathering

CREATE DATABASE IF NOT EXISTS msa_gathering CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

GRANT ALL PRIVILEGES ON msa_gathering.* TO 'msa'@'localhost';

FLUSH PRIVILEGES;

- Account

CREATE DATABASE msa_account CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

GRANT ALL PRIVILEGES ON msa_account.* TO 'msa'@'localhost';

FLUSH PRIVILEGES; 

- Information

CREATE DATABASE msa_information CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

GRANT ALL PRIVILEGES ON msa_information.* TO 'msa'@'localhost';

FLUSH PRIVILEGES; 

- QnA

CREATE DATABASE msa_qna CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

GRANT ALL PRIVILEGES ON msa_qna.* TO 'msa'@'localhost';

FLUSH PRIVILEGES; 

- Board