aboutsummaryrefslogtreecommitdiff
path: root/sql/create/drop_mysql.sql
diff options
context:
space:
mode:
authorXanadu <none@none>2010-07-20 02:49:28 +0200
committerXanadu <none@none>2010-07-20 02:49:28 +0200
commit79622802f397258ee0f34327ba3ae6977ca3e7ff (patch)
tree1868946c234ab9ee256a6b7766a15713eae94235 /sql/create/drop_mysql.sql
parent7dd2dc91816ab8b3bc3b99a1b1c99c7ea314d5a8 (diff)
parentf906976837502fa5aa81b982b901d1509f5aa0c4 (diff)
Merge. Revision history for source files should be all back now.
--HG-- branch : trunk rename : sql/CMakeLists.txt => sql/tools/CMakeLists.txt rename : src/server/game/Pools/PoolHandler.cpp => src/server/game/Pools/PoolMgr.cpp rename : src/server/game/Pools/PoolHandler.h => src/server/game/Pools/PoolMgr.h rename : src/server/game/PrecompiledHeaders/NixCorePCH.cpp => src/server/game/PrecompiledHeaders/gamePCH.cpp rename : src/server/game/PrecompiledHeaders/NixCorePCH.h => src/server/game/PrecompiledHeaders/gamePCH.h
Diffstat (limited to 'sql/create/drop_mysql.sql')
-rw-r--r--sql/create/drop_mysql.sql21
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/create/drop_mysql.sql b/sql/create/drop_mysql.sql
new file mode 100644
index 00000000000..ee05439df99
--- /dev/null
+++ b/sql/create/drop_mysql.sql
@@ -0,0 +1,21 @@
+REVOKE ALL PRIVILEGES ON * . * FROM 'trinity'@'localhost';
+
+REVOKE ALL PRIVILEGES ON `world` . * FROM 'trinity'@'localhost';
+
+REVOKE GRANT OPTION ON `world` . * FROM 'trinity'@'localhost';
+
+REVOKE ALL PRIVILEGES ON `characters` . * FROM 'trinity'@'localhost';
+
+REVOKE GRANT OPTION ON `characters` . * FROM 'trinity'@'localhost';
+
+REVOKE ALL PRIVILEGES ON `auth` . * FROM 'trinity'@'localhost';
+
+REVOKE GRANT OPTION ON `auth` . * FROM 'trinity'@'localhost';
+
+DROP USER 'trinity'@'localhost';
+
+DROP DATABASE IF EXISTS `world`;
+
+DROP DATABASE IF EXISTS `characters`;
+
+DROP DATABASE IF EXISTS `auth`;