DB: Add drop script compatible with MySQL 8

(cherry picked from commit 7e5c1cf453972e142613ab828b75c8635edf697d)

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/create/drop_mysql_8.sql b/sql/create/drop_mysql_8.sql
new file mode 100644
index 00000000000..b4a06e76781
--- /dev/null
+++ b/sql/create/drop_mysql_8.sql
@@ -0,0 +1,11 @@
+REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'trinity'@'localhost';
+
+DROP USER 'trinity'@'localhost';
+
+DROP DATABASE IF EXISTS `world`;
+
+DROP DATABASE IF EXISTS `characters`;
+
+DROP DATABASE IF EXISTS `auth`;
+
+DROP DATABASE IF EXISTS `hotfixes`;