From 79250cb0df11c7ba6f7b3b482deea89eb3f93190 Mon Sep 17 00:00:00 2001 From: jackpoz Date: Sun, 31 May 2020 14:53:13 +0200 Subject: CI/CircleCI: Switch to Ubuntu 20.04 and MySQL 8 (cherry picked from commit e3dfab52a639275ea130d279f4a6fe4312d34b06) --- sql/create/create_mysql.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'sql') 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; -- cgit v1.2.3