SO mariadb scripts failure if user exists

[so/docker-config.git] / volumes / mariadb / docker-entrypoint-initdb.d / 05-create-so-admin.sh

diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/05-create-so-admin.sh b/volumes/mariadb/docker-entrypoint-initdb.d/05-create-so-admin.sh
index d31159a..6eb3baa 100644 (file)
--- a/volumes/mariadb/docker-entrypoint-initdb.d/05-create-so-admin.sh
+++ b/volumes/mariadb/docker-entrypoint-initdb.d/05-create-so-admin.sh
@@ -24,7 +24,7 @@
 echo "Creating so admin user . . ." 1>/tmp/mariadb-so-admin.log 2>&1
 
 mysql -uroot -p$MYSQL_ROOT_PASSWORD << 'EOF' || exit 1
-DELETE FROM mysql.user WHERE User='so_admin';
+DROP USER IF EXISTS 'so_admin';
 CREATE USER 'so_admin';
 GRANT USAGE ON *.* TO 'so_admin'@'%' IDENTIFIED BY 'so_Admin123';
 GRANT ALL PRIVILEGES ON `camundabpmn`.* TO 'so_admin'@'%' WITH GRANT OPTION;
@@ -33,4 +33,4 @@ GRANT ALL PRIVILEGES ON `catalogdb`.* TO 'so_admin'@'%' WITH GRANT OPTION;
 FLUSH PRIVILEGES;
 EOF
 
-echo "Created so admin user . . ." 1>>/tmp/mariadb-so-admin.log 2>&1
\ No newline at end of file
+echo "Created so admin user . . ." 1>>/tmp/mariadb-so-admin.log 2>&1