mirror of
https://github.com/cmangos/mangos-tbc
synced 2026-08-14 04:26:10 -04:00
17 lines
969 B
SQL
17 lines
969 B
SQL
CREATE DATABASE `tbcmangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
|
|
|
CREATE DATABASE `tbclogs` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
|
|
|
CREATE DATABASE `tbccharacters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
|
|
|
CREATE DATABASE `tbcrealmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
|
|
|
CREATE USER IF NOT EXISTS 'mangos'@'localhost' IDENTIFIED BY 'mangos';
|
|
|
|
GRANT INDEX, SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `tbcmangos`.* TO 'mangos'@'localhost';
|
|
|
|
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `tbclogs`.* TO 'mangos'@'localhost';
|
|
|
|
GRANT INDEX, SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `tbccharacters`.* TO 'mangos'@'localhost';
|
|
|
|
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `tbcrealmd`.* TO 'mangos'@'localhost';
|