~mser/vmangos-docker

ref: 3322b303e1c3f5090b33fb6c7683975b93bdd329 vmangos-docker/docker/database/generate-db-1.sql -rw-r--r-- 809 bytes
3322b303Michael Serajnik Only set DEBIAN_FRONTEND during image build 1 year, 1 month 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;