~mser/vmangos-docker

ref: 82e7f20944f3301b328de28791c4aaaa9e5b0ee4 vmangos-docker/docker/database/generate-db-1.sql -rw-r--r-- 809 bytes
82e7f209Michael Serajnik Rebuild Docker images without using cache 1 year, 3 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;