diff options
| author | Sean McGinnis <sean.mcginnis@gmail.com> | 2020-06-30 08:14:10 -0500 |
|---|---|---|
| committer | Sean McGinnis <sean.mcginnis@gmail.com> | 2020-06-30 08:14:10 -0500 |
| commit | 2a9761bece22b58df6c7616f9bdcf0589f6af77f (patch) | |
| tree | 5cdbe726ba2f52dee6c51bcd1a41a1b10f4068cb | |
| parent | 47db4d083d868736450dc5471512c3a15c23b3fc (diff) | |
| download | taskflow-2a9761bece22b58df6c7616f9bdcf0589f6af77f.tar.gz | |
Make test-setup.sh compatible with mysql84.3.1
Starting from mysql version 8 it's not possible to create a user
implictly when using GRANT.
This patch makes the behavior compatible with that.
Change-Id: I10dacfe8fa425a1b1dfd4b8862a7460caa5c579f
Co-written-by: Riccardo Pittau <elfosardo@gmail.com>
Signed-off-by: Sean McGinnis <sean.mcginnis@gmail.com>
| -rwxr-xr-x | tools/test-setup.sh | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/tools/test-setup.sh b/tools/test-setup.sh index ab662a4..8b42087 100755 --- a/tools/test-setup.sh +++ b/tools/test-setup.sh @@ -23,8 +23,8 @@ sudo -H mysqladmin -u root password $DB_ROOT_PW sudo -H mysql -u root -p$DB_ROOT_PW -h localhost -e " DELETE FROM mysql.user WHERE User=''; FLUSH PRIVILEGES; - GRANT ALL PRIVILEGES ON *.* - TO '$DB_USER'@'%' identified by '$DB_PW' WITH GRANT OPTION;" + CREATE USER '$DB_USER'@'%' IDENTIFIED BY '$DB_PW'; + GRANT ALL PRIVILEGES ON *.* TO '$DB_USER'@'%' WITH GRANT OPTION;" # Now create our database. mysql -u $DB_USER -p$DB_PW -h 127.0.0.1 -e " |