X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=resources%2Fdbscripts%2Fmysql%2Fmodeling-etsicatalog-createdb.sql;fp=resources%2Fdbscripts%2Fmysql%2Fmodeling-etsicatalog-createdb.sql;h=0000000000000000000000000000000000000000;hb=b56448fa7f0faeffb79541164f8c9bd3983d05ab;hp=c6a71ab20ffbecca79a9a18427c51edcbff95a19;hpb=46bd3041d522ddce28ae3450e98c9c49b44b02cc;p=modeling%2Fetsicatalog.git diff --git a/resources/dbscripts/mysql/modeling-etsicatalog-createdb.sql b/resources/dbscripts/mysql/modeling-etsicatalog-createdb.sql deleted file mode 100644 index c6a71ab..0000000 --- a/resources/dbscripts/mysql/modeling-etsicatalog-createdb.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright 2018 ZTE Corporation. --- --- Licensed under the Apache License, Version 2.0 (the "License"); --- you may not use this file except in compliance with the License. --- You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -/******************create database and user***************************/ -use mysql; - -create database if not exists etsicatalog CHARACTER SET utf8; - - -GRANT ALL PRIVILEGES ON etsicatalog.* TO 'etsicatalog'@'%' IDENTIFIED BY 'etsicatalog' WITH GRANT OPTION; -GRANT ALL PRIVILEGES ON mysql.* TO 'etsicatalog'@'%' IDENTIFIED BY 'etsicatalog' WITH GRANT OPTION; - -GRANT ALL PRIVILEGES ON etsicatalog.* TO 'etsicatalog'@'localhost' IDENTIFIED BY 'etsicatalog' WITH GRANT OPTION; -GRANT ALL PRIVILEGES ON mysql.* TO 'etsicatalog'@'localhost' IDENTIFIED BY 'etsicatalog' WITH GRANT OPTION; -FLUSH PRIVILEGES;