Mariadb scripts for containerized environment

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

diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/01-load-default-sql-files.sh b/volumes/mariadb/docker-entrypoint-initdb.d/02-create-requestdb.sh
similarity index 70%
rename from volumes/mariadb/docker-entrypoint-initdb.d/01-load-default-sql-files.sh
rename to volumes/mariadb/docker-entrypoint-initdb.d/02-create-requestdb.sh
index 326f273..f2231b6 100644 (file)
--- a/volumes/mariadb/docker-entrypoint-initdb.d/01-load-default-sql-files.sh
+++ b/volumes/mariadb/docker-entrypoint-initdb.d/02-create-requestdb.sh
@@ -20,6 +20,14 @@
 # ECOMP and OpenECOMP are trademarks
 # and service marks of AT&T Intellectual Property.
 #
-#
-cd /docker-entrypoint-initdb.d/db-sql-scripts/bulkload-files/demo-vfw
-mysql -uroot -p$MYSQL_ROOT_PASSWORD -f < create_mso_db-demo-vfw.sql
\ No newline at end of file
+
+echo "Creating requestdb database . . ."
+
+mysql -uroot -p$MYSQL_ROOT_PASSWORD << 'EOF' || exit 1
+DROP DATABASE IF EXISTS `requestdb`;
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `requestdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
+DELETE FROM mysql.user WHERE User='requestuser';
+CREATE USER 'requestuser';
+GRANT ALL on requestdb.* to 'requestuser' identified by 'request123' with GRANT OPTION;
+FLUSH PRIVILEGES;
+EOF