diff options
| author | jackpoz <giacomopoz@gmail.com> | 2020-05-31 14:53:13 +0200 |
|---|---|---|
| committer | jackpoz <giacomopoz@gmail.com> | 2020-05-31 15:40:15 +0200 |
| commit | e3dfab52a639275ea130d279f4a6fe4312d34b06 (patch) | |
| tree | 02f54f506359af5046ffdb9a5288c1a8d62aacc3 /sql/create/create_mysql.sql | |
| parent | 8c09b6e58b0e4f33b7a8e376a28709e693cf2914 (diff) | |
CI/CircleCI: Switch to Ubuntu 20.04 and MySQL 8
Diffstat (limited to 'sql/create/create_mysql.sql')
| -rw-r--r-- | sql/create/create_mysql.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/create/create_mysql.sql b/sql/create/create_mysql.sql index e182e06168f..c7a1b12cc27 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 utf8 COLLATE utf8_general_ci; |