From ca8f0a53b3a9b146039b5be5e0dea246bf37a538 Mon Sep 17 00:00:00 2001 From: XTZGZoReX Date: Mon, 7 Jun 2010 01:44:40 +0200 Subject: * Cleanup in sql directory. --HG-- branch : trunk --- sql/tools/drop_mysql.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/tools/drop_mysql.sql (limited to 'sql/tools/drop_mysql.sql') diff --git a/sql/tools/drop_mysql.sql b/sql/tools/drop_mysql.sql new file mode 100644 index 00000000000..c0ec81e378f --- /dev/null +++ b/sql/tools/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 `realmd` . * FROM 'trinity'@'localhost'; + +REVOKE GRANT OPTION ON `realmd` . * FROM 'trinity'@'localhost'; + +DROP USER 'trinity'@'localhost'; + +DROP DATABASE IF EXISTS `world`; + +DROP DATABASE IF EXISTS `characters`; + +DROP DATABASE IF EXISTS `realmd`; -- cgit v1.2.3