aboutsummaryrefslogtreecommitdiff
path: root/sql/create/drop_mysql_8.sql
diff options
context:
space:
mode:
authorGiacomo Pozzoni <giacomopoz@gmail.com>2021-05-13 16:55:01 +0200
committerGiacomo Pozzoni <giacomopoz@gmail.com>2021-05-13 17:08:31 +0200
commit7e5c1cf453972e142613ab828b75c8635edf697d (patch)
tree04d16ac941efce980f2aed2fa87782b7b46f4c87 /sql/create/drop_mysql_8.sql
parentaa070ebf864af1c6cf2c181864588a2a8cbbecbf (diff)
DB: Add drop script compatible with MySQL 8
Diffstat (limited to 'sql/create/drop_mysql_8.sql')
-rw-r--r--sql/create/drop_mysql_8.sql9
1 files changed, 9 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..213bc2e926c
--- /dev/null
+++ b/sql/create/drop_mysql_8.sql
@@ -0,0 +1,9 @@
+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`;