diff options
Diffstat (limited to 'sql/tools/drop_mysql.sql')
-rw-r--r-- | sql/tools/drop_mysql.sql | 21 |
1 files changed, 21 insertions, 0 deletions
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`; |