Altered create database db statements

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

diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/04-create-so-user.sh b/volumes/mariadb/docker-entrypoint-initdb.d/04-create-so-user.sh
index d6d1c20..099d09f 100644 (file)
--- a/volumes/mariadb/docker-entrypoint-initdb.d/04-create-so-user.sh
+++ b/volumes/mariadb/docker-entrypoint-initdb.d/04-create-so-user.sh
@@ -21,10 +21,11 @@
 # and service marks of AT&T Intellectual Property.
 #
 
-echo "Creating so user . . ."
+echo "Creating so user . . ." 1>/tmp/mariadb-so-user.log 2>&1
 
 mysql -uroot -p$MYSQL_ROOT_PASSWORD << 'EOF' || exit 1
 DELETE FROM mysql.user WHERE User='so_user';
+DROP USER IF EXISTS 'so_user';
 CREATE USER 'so_user';
 GRANT USAGE ON *.* TO 'so_user'@'%' IDENTIFIED BY 'so_User123';
 GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, SHOW VIEW ON `requestdb`.* TO 'so_user'@'%';
@@ -32,3 +33,5 @@ GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, SHOW VIEW ON `catalogdb`.* TO 'so
 GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, SHOW VIEW ON `camundabpmn`.* TO 'so_user'@'%';
 FLUSH PRIVILEGES;
 EOF
+
+echo "Created so user . . ." 1>>/tmp/mariadb-so-user.log 2>&1
\ No newline at end of file