SO mariadb scripts failure if user exists

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

diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh b/volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh
index 0ce6c37..10fb4b1 100644 (file)
--- a/volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh
+++ b/volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh
@@ -26,10 +26,10 @@ echo "Creating catalogdb database . . ." 1>/tmp/mariadb-catalogdb.log 2>&1
 mysql -uroot -p$MYSQL_ROOT_PASSWORD << 'EOF' || exit 1
 DROP DATABASE IF EXISTS `catalogdb`;
 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `catalogdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
-DELETE FROM mysql.user WHERE User='cataloguser';
+DROP USER IF EXISTS 'cataloguser';
 CREATE USER 'cataloguser';
 GRANT ALL on catalogdb.* to 'cataloguser' identified by 'catalog123' with GRANT OPTION;
 FLUSH PRIVILEGES;
 EOF
 
-echo "Created catalogdb database . . ." 1>>/tmp/mariadb-catalogdb.log 2>&1
\ No newline at end of file
+echo "Created catalogdb database . . ." 1>>/tmp/mariadb-catalogdb.log 2>&1