~mser/vmangos-docker

ref: bf6a0a94124a91b37028402f6513c04d153f5079 vmangos-docker/docker/database/generate-db-1.sql -rw-r--r-- 809 bytes
bf6a0a94Michael Serajnik Unify SQL formatting 6 months ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
CREATE DATABASE IF NOT EXISTS realmd DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS characters DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS mangos DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS logs DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
CREATE USER 'mangos'@'localhost' IDENTIFIED BY 'mangos';
SET PASSWORD FOR 'mangos'@'localhost' = PASSWORD('mangos');
GRANT ALL PRIVILEGES ON *.* TO 'mangos'@'%' IDENTIFIED BY 'mangos';
FLUSH PRIVILEGES;
GRANT ALL ON realmd.* TO mangos@'localhost' WITH GRANT OPTION;
GRANT ALL ON characters.* TO mangos@'localhost' WITH GRANT OPTION;
GRANT ALL ON mangos.* TO mangos@'localhost' WITH GRANT OPTION;
GRANT ALL ON logs.* TO mangos@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;