diff options
author | Neo2003 <none@none> | 2008-10-02 16:23:55 -0500 |
---|---|---|
committer | Neo2003 <none@none> | 2008-10-02 16:23:55 -0500 |
commit | 9b1c0e006f20091f28f3f468cfcab1feb51286bd (patch) | |
tree | b5d1ba94a656e6679f8737f9ea6bed1239b73b14 /sql/drop_mysql.sql |
[svn] * Proper SVN structureinit
--HG--
branch : trunk
Diffstat (limited to 'sql/drop_mysql.sql')
-rw-r--r-- | sql/drop_mysql.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/drop_mysql.sql b/sql/drop_mysql.sql new file mode 100644 index 00000000000..4ed3f55472e --- /dev/null +++ b/sql/drop_mysql.sql @@ -0,0 +1,21 @@ +REVOKE ALL PRIVILEGES ON * . * FROM 'mangos'@'localhost'; + +REVOKE ALL PRIVILEGES ON `mangos` . * FROM 'mangos'@'localhost'; + +REVOKE GRANT OPTION ON `mangos` . * FROM 'mangos'@'localhost'; + +REVOKE ALL PRIVILEGES ON `characters` . * FROM 'mangos'@'localhost'; + +REVOKE GRANT OPTION ON `characters` . * FROM 'mangos'@'localhost'; + +REVOKE ALL PRIVILEGES ON `realmd` . * FROM 'mangos'@'localhost'; + +REVOKE GRANT OPTION ON `realmd` . * FROM 'mangos'@'localhost'; + +DELETE FROM `user` WHERE CONVERT( User USING utf8 ) = CONVERT( 'mangos' USING utf8 ) AND CONVERT( Host USING utf8 ) = CONVERT( 'localhost' USING utf8 ) ; + +DROP DATABASE IF EXISTS `mangos` ; + +DROP DATABASE IF EXISTS `characters` ; + +DROP DATABASE IF EXISTS `realmd` ; |