From 528e9959e8f50cf3d7a4f88516f9acaee6e838d4 Mon Sep 17 00:00:00 2001
From: Giacomo Pozzoni <giacomopoz@gmail.com>
Date: Thu, 13 May 2021 16:55:01 +0200
Subject: DB: Add drop script compatible with MySQL 8

(cherry picked from commit 7e5c1cf453972e142613ab828b75c8635edf697d)
---
 sql/create/drop_mysql_8.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 sql/create/drop_mysql_8.sql

(limited to 'sql')

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`;
-- 
cgit v1.2.3