diff options
Diffstat (limited to 'volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh')
-rw-r--r-- | volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh | 6 |
1 files changed, 4 insertions, 2 deletions
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 aa47f65..4cef914 100644 --- a/volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh +++ b/volumes/mariadb/docker-entrypoint-initdb.d/03-create-catalogdb.sh @@ -21,14 +21,16 @@ # and service marks of AT&T Intellectual Property. # -echo "Creating catalogdb database . . ." +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 '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 |