From 6e702cc6d82cfcaf79735ec2840cf294458bbb92 Mon Sep 17 00:00:00 2001 From: yangyan Date: Wed, 3 Apr 2019 10:55:35 +0800 Subject: fix database bug Change-Id: Id4c1149ee3d1d348abe02cd92324499e4158201b Issue-ID: VFC-1334 Signed-off-by: yangyan --- resources/dbscripts/mysql/vfc-nfvo-lcm-createdb.sql | 8 ++------ 1 file changed, 2 insertions(+), 6 deletions(-) (limited to 'resources/dbscripts') diff --git a/resources/dbscripts/mysql/vfc-nfvo-lcm-createdb.sql b/resources/dbscripts/mysql/vfc-nfvo-lcm-createdb.sql index 94e630b5..bd90a1fa 100644 --- a/resources/dbscripts/mysql/vfc-nfvo-lcm-createdb.sql +++ b/resources/dbscripts/mysql/vfc-nfvo-lcm-createdb.sql @@ -14,14 +14,10 @@ -- limitations under the License. -- -/******************drop old database and user***************************/ +/******************create database and user***************************/ use mysql; -drop database IF EXISTS vfcnfvolcm; -delete from user where User='vfcnfvolcm'; -FLUSH PRIVILEGES; +create database if not exists vfcnfvolcm CHARACTER SET utf8; -/******************create new database and user***************************/ -create database vfcnfvolcm CHARACTER SET utf8; GRANT ALL PRIVILEGES ON vfcnfvolcm.* TO 'vfcnfvolcm'@'%' IDENTIFIED BY 'vfcnfvolcm' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON mysql.* TO 'vfcnfvolcm'@'%' IDENTIFIED BY 'vfcnfvolcm' WITH GRANT OPTION; -- cgit 1.2.3-korg