summaryrefslogtreecommitdiffstats
path: root/mgr/docker/createdb.sql
diff options
context:
space:
mode:
authorShashank Kumar Shankar <shashank.kumar.shankar@intel.com>2017-09-05 15:52:48 -0700
committerShashank Kumar Shankar <shashank.kumar.shankar@intel.com>2017-09-06 15:43:58 -0700
commitd816d444383c73862535c89483c01e0d125a722c (patch)
tree29217fce57467df58742a792b5d66cb17629fbb6 /mgr/docker/createdb.sql
parentdff6a11d425677eec5909d2cdab9cc1c277719c7 (diff)
Add GVNFM VNFMGR Docker image and build scripts
This patch adds the scripts and Dockerfile for building GVNFM/VNFGR docker image. Change-Id: I4642228523691095ff77cd5fa0007d853e93b7d5 Issue-Id: VFC-282 Signed-off-by: Shashank Kumar Shankar <shashank.kumar.shankar@intel.com>
Diffstat (limited to 'mgr/docker/createdb.sql')
-rw-r--r--mgr/docker/createdb.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/mgr/docker/createdb.sql b/mgr/docker/createdb.sql
new file mode 100644
index 0000000..41d2435
--- /dev/null
+++ b/mgr/docker/createdb.sql
@@ -0,0 +1,15 @@
+/******************drop old database and user***************************/
+use mysql;
+drop database IF EXISTS gvnfm;
+delete from user where User='gvnfm';
+FLUSH PRIVILEGES;
+
+/******************create new database and user***************************/
+create database gvnfm CHARACTER SET utf8;
+
+GRANT ALL PRIVILEGES ON gvnfm.* TO 'gvnfm'@'%' IDENTIFIED BY 'gvnfm' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON mysql.* TO 'gvnfm'@'%' IDENTIFIED BY 'gvnfm' WITH GRANT OPTION;
+
+GRANT ALL PRIVILEGES ON gvnfm.* TO 'gvnfm'@'localhost' IDENTIFIED BY 'gvnfm' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON mysql.* TO 'gvnfm'@'localhost' IDENTIFIED BY 'gvnfm' WITH GRANT OPTION;
+FLUSH PRIVILEGES; \ No newline at end of file