aboutsummaryrefslogtreecommitdiff
path: root/sql/create/create_mysql.sql
diff options
context:
space:
mode:
authorjackpoz <giacomopoz@gmail.com>2020-05-31 14:53:13 +0200
committerfunjoker <funjoker109@gmail.com>2022-01-02 21:29:32 +0100
commit79250cb0df11c7ba6f7b3b482deea89eb3f93190 (patch)
tree6d5bcc9898b81ff348806edcb357fbe558f7dcaf /sql/create/create_mysql.sql
parentc981af6b3106a7319960866ea012670cfa789915 (diff)
CI/CircleCI: Switch to Ubuntu 20.04 and MySQL 8
(cherry picked from commit e3dfab52a639275ea130d279f4a6fe4312d34b06)
Diffstat (limited to 'sql/create/create_mysql.sql')
-rw-r--r--sql/create/create_mysql.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/create/create_mysql.sql b/sql/create/create_mysql.sql
index f9c230b6ced..6dd3da0f50c 100644
--- a/sql/create/create_mysql.sql
+++ b/sql/create/create_mysql.sql
@@ -1,4 +1,6 @@
-GRANT USAGE ON * . * TO 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
+CREATE USER 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;
+
+GRANT USAGE ON * . * TO 'trinity'@'localhost';
CREATE DATABASE `world` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;