mirror of
https://github.com/cmangos/mangos-classic
synced 2026-08-14 02:23:08 -04:00
222f4c5d04
Be sure to also update DB too using updated install script. close https://github.com/cmangos/mangos-classic/pull/528
17 lines
No EOL
1,000 B
SQL
17 lines
No EOL
1,000 B
SQL
CREATE DATABASE `classicmangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
|
|
|
CREATE DATABASE `classiclogs` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
|
|
|
CREATE DATABASE `classiccharacters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
|
|
|
CREATE DATABASE `classicrealmd` 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 `classicmangos`.* TO 'mangos'@'localhost';
|
|
|
|
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `classiclogs`.* TO 'mangos'@'localhost';
|
|
|
|
GRANT INDEX, SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `classiccharacters`.* TO 'mangos'@'localhost';
|
|
|
|
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `classicrealmd`.* TO 'mangos'@'localhost'; |