diff options
| author |   Fu Jinhua <fu.jinhua@zte.com.cn> | 2019-04-03 04:15:20 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2019-04-03 04:15:20 +0000 |
| commit | 4af6d0c521c1a704cb1ec78e304d58640c3d5da9 (patch) | |
| tree | fe8748a744164d217cc8c7e34457d355b147d0a6 /resources/dbscripts | |
| parent | 12d1a18d4d03702ea6d0ff57d4c121aa67831e0d (diff) | |
| parent | 6e702cc6d82cfcaf79735ec2840cf294458bbb92 (diff) | |
Merge "fix database bug"
Diffstat (limited to 'resources/dbscripts')
| -rw-r--r-- | resources/dbscripts/mysql/vfc-nfvo-lcm-createdb.sql | 8 |
1 files changed, 2 insertions, 6 deletions
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; |