diff options
Diffstat (limited to 'resources/dbscripts/mysql/vfc-nfvo-catalog-createdb.sql')
| -rw-r--r-- | resources/dbscripts/mysql/vfc-nfvo-catalog-createdb.sql | 9 |
1 files changed, 3 insertions, 6 deletions
diff --git a/resources/dbscripts/mysql/vfc-nfvo-catalog-createdb.sql b/resources/dbscripts/mysql/vfc-nfvo-catalog-createdb.sql index a1fd3e2c..791bd7f5 100644 --- a/resources/dbscripts/mysql/vfc-nfvo-catalog-createdb.sql +++ b/resources/dbscripts/mysql/vfc-nfvo-catalog-createdb.sql @@ -14,14 +14,11 @@ -- limitations under the License. -- -/******************drop old database and user***************************/ +/******************create database and user***************************/ use mysql; -drop database IF EXISTS nfvocatalog; -delete from user where User='nfvocatalog'; -FLUSH PRIVILEGES; -/******************create new database and user***************************/ -create database nfvocatalog CHARACTER SET utf8; +create database if not exists nfvocatalog CHARACTER SET utf8; + GRANT ALL PRIVILEGES ON nfvocatalog.* TO 'nfvocatalog'@'%' IDENTIFIED BY 'nfvocatalog' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON mysql.* TO 'nfvocatalog'@'%' IDENTIFIED BY 'nfvocatalog' WITH GRANT OPTION; |