Changeset 35 for trunk/sql/create_mysql.sql
- Timestamp:
- 11/19/08 13:25:48 (17 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/sql/create_mysql.sql
r2 r35 1 GRANT USAGE ON * . * TO ' mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;1 GRANT USAGE ON * . * TO 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ; 2 2 3 CREATE DATABASE ` mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;3 CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 4 4 5 5 CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; … … 7 7 CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 8 8 9 GRANT ALL PRIVILEGES ON ` mangos` . * TO 'mangos'@'localhost' WITH GRANT OPTION;9 GRANT ALL PRIVILEGES ON `world` . * TO 'trinity'@'localhost' WITH GRANT OPTION; 10 10 11 GRANT ALL PRIVILEGES ON `characters` . * TO ' mangos'@'localhost' WITH GRANT OPTION;11 GRANT ALL PRIVILEGES ON `characters` . * TO 'trinity'@'localhost' WITH GRANT OPTION; 12 12 13 GRANT ALL PRIVILEGES ON `realmd` . * TO ' mangos'@'localhost' WITH GRANT OPTION;13 GRANT ALL PRIVILEGES ON `realmd` . * TO 'trinity'@'localhost' WITH GRANT OPTION; 14 14