Changeset 35 for trunk/sql/drop_mysql.sql
- Timestamp:
- 11/19/08 13:25:48 (17 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/sql/drop_mysql.sql
r2 r35 1 REVOKE ALL PRIVILEGES ON * . * FROM ' mangos'@'localhost';1 REVOKE ALL PRIVILEGES ON * . * FROM 'trinity'@'localhost'; 2 2 3 REVOKE ALL PRIVILEGES ON `mangos` . * FROM ' mangos'@'localhost';3 REVOKE ALL PRIVILEGES ON `mangos` . * FROM 'trinity'@'localhost'; 4 4 5 REVOKE GRANT OPTION ON `mangos` . * FROM ' mangos'@'localhost';5 REVOKE GRANT OPTION ON `mangos` . * FROM 'trinity'@'localhost'; 6 6 7 REVOKE ALL PRIVILEGES ON `characters` . * FROM ' mangos'@'localhost';7 REVOKE ALL PRIVILEGES ON `characters` . * FROM 'trinity'@'localhost'; 8 8 9 REVOKE GRANT OPTION ON `characters` . * FROM ' mangos'@'localhost';9 REVOKE GRANT OPTION ON `characters` . * FROM 'trinity'@'localhost'; 10 10 11 REVOKE ALL PRIVILEGES ON `realmd` . * FROM ' mangos'@'localhost';11 REVOKE ALL PRIVILEGES ON `realmd` . * FROM 'trinity'@'localhost'; 12 12 13 REVOKE GRANT OPTION ON `realmd` . * FROM ' mangos'@'localhost';13 REVOKE GRANT OPTION ON `realmd` . * FROM 'trinity'@'localhost'; 14 14 15 DELETE FROM `user` WHERE CONVERT( User USING utf8 ) = CONVERT( ' mangos' USING utf8 ) AND CONVERT( Host USING utf8 ) = CONVERT( 'localhost' USING utf8 ) ;15 DELETE FROM `user` WHERE CONVERT( User USING utf8 ) = CONVERT( 'trinity' USING utf8 ) AND CONVERT( Host USING utf8 ) = CONVERT( 'localhost' USING utf8 ) ; 16 16 17 DROP DATABASE IF EXISTS ` mangos` ;17 DROP DATABASE IF EXISTS `world` ; 18 18 19 19 DROP DATABASE IF EXISTS `characters` ;