~mser/vmangos-docker

ref: c47d3eef9e7cb973330e36047f957a94378291c8 vmangos-docker/docker/database/generate-db-1.sql -rw-r--r-- 1.5 KiB
c47d3eefMichael Serajnik Add missing license notices 1 year, 3 months ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
-- vmangos-docker
-- Copyright (C) 2021-present  Michael Serajnik  https://sr.ht/~mser/

-- This program is free software: you can redistribute it and/or modify
-- it under the terms of the GNU Affero General Public License as published by
-- the Free Software Foundation, either version 3 of the License, or
-- (at your option) any later version.

-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU Affero General Public License for more details.

-- You should have received a copy of the GNU Affero General Public License
-- along with this program.  If not, see <http://www.gnu.org/licenses/>.

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;