diff options
| author |   fujinhua <fu.jinhua@zte.com.cn> | 2019-04-03 09:18:28 +0800 |
|---|---|---|
| committer | fujinhua <fu.jinhua@zte.com.cn> | 2019-04-03 09:18:28 +0800 |
| commit | d832753cefc69cb5813316c789319b1aaff2aba8 (patch) | |
| tree | 0582965fbfbea0cb7fe10c8e9c73fa9202092c4d /lcm/resources | |
| parent | e7891e6a0d35b2d427305fdfdc63aba6ea79a0cb (diff) | |
Fix docker init db file
Change-Id: I8b4a04768d4816775606861cd2d598acc8939100
Issue-ID: VFC-1306
Signed-off-by: fujinhua <fu.jinhua@zte.com.cn>
Diffstat (limited to 'lcm/resources')
| -rwxr-xr-x | lcm/resources/bin/initDB.sh | 7 | ||||
| -rw-r--r-- | lcm/resources/dbscripts/mysql/onap-gvnfm-vnfres-createdb.sql | 9 |
2 files changed, 6 insertions, 10 deletions
diff --git a/lcm/resources/bin/initDB.sh b/lcm/resources/bin/initDB.sh index 764ac1ac..5386170b 100755 --- a/lcm/resources/bin/initDB.sh +++ b/lcm/resources/bin/initDB.sh @@ -26,10 +26,9 @@ sql_path=$HOME/../ mysql -u$MYSQL_USER -p$MYSQL_PASSWORD -P$MYSQL_PORT -h$MYSQL_IP <$sql_path/dbscripts/mysql/onap-gvnfm-vnfres-createdb.sql sql_result=$? if [ $sql_result -ne 0 ] ; then - echo "failed to create gvnfm database" + echo "Failed to create gvnfm database" exit 1 -elif [ $sql_result -eq 0 ]; then - echo "create gvnfm database successfully" +else + echo "Create gvnfm database successfully" exit 0 fi - diff --git a/lcm/resources/dbscripts/mysql/onap-gvnfm-vnfres-createdb.sql b/lcm/resources/dbscripts/mysql/onap-gvnfm-vnfres-createdb.sql index 79133432..aebcd6b7 100644 --- a/lcm/resources/dbscripts/mysql/onap-gvnfm-vnfres-createdb.sql +++ b/lcm/resources/dbscripts/mysql/onap-gvnfm-vnfres-createdb.sql @@ -12,18 +12,15 @@ -- See the License for the specific language governing permissions and -- limitations under the License. -/******************drop old database and user***************************/ +/******************create 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; +create database if not exists 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; |