diff options
author | 2019-09-05 00:56:32 +0000 | |
---|---|---|
committer | 2019-09-05 00:56:32 +0000 | |
commit | 5fd2ae6a4517980ce0f89247bb354220748ae67b (patch) | |
tree | 0569d08b8eddf72c6c402cd3e8b681ed9e56621a /resources | |
parent | 842a4fd77b1c9f93a4b97bd7f138c9b35a855d13 (diff) | |
parent | a32c2b20207885d895bd96204cc166fca14db97b (diff) |
Merge "update for change to etsicatalog"
Diffstat (limited to 'resources')
-rwxr-xr-x | resources/bin/initDB.sh | 8 | ||||
-rw-r--r-- | resources/dbscripts/mysql/modeling-etsicatalog-createdb.sql (renamed from resources/dbscripts/mysql/modeling-gengricparser-createdb.sql) | 8 |
2 files changed, 8 insertions, 8 deletions
diff --git a/resources/bin/initDB.sh b/resources/bin/initDB.sh index 7d87e5d..85b61d9 100755 --- a/resources/bin/initDB.sh +++ b/resources/bin/initDB.sh @@ -20,15 +20,15 @@ MYSQL_USER=$1 MYSQL_PASSWORD=$2 MYSQL_PORT=$3 MYSQL_IP=$4 -echo "start create gengricparser db" +echo "start create etsicatalog db" sql_path=$HOME/../ -mysql -u$MYSQL_USER -p$MYSQL_PASSWORD -P$MYSQL_PORT -h$MYSQL_IP <$sql_path/dbscripts/mysql/modeling-gengricparser-createdb.sql +mysql -u$MYSQL_USER -p$MYSQL_PASSWORD -P$MYSQL_PORT -h$MYSQL_IP <$sql_path/dbscripts/mysql/modeling-etsicatalog-createdb.sql sql_result=$? if [ $sql_result -ne 0 ] ; then - echo "Failed to create gengricparser database" + echo "Failed to create etsicatalog database" exit 1 else - echo "Create gengricparser database successfully" + echo "Create etsicatalog database successfully" exit 0 fi diff --git a/resources/dbscripts/mysql/modeling-gengricparser-createdb.sql b/resources/dbscripts/mysql/modeling-etsicatalog-createdb.sql index d868899..e3fc2ba 100644 --- a/resources/dbscripts/mysql/modeling-gengricparser-createdb.sql +++ b/resources/dbscripts/mysql/modeling-etsicatalog-createdb.sql @@ -20,9 +20,9 @@ use mysql; create database if not exists genericparser CHARACTER SET utf8; -GRANT ALL PRIVILEGES ON genericparser.* TO 'genericparser'@'%' IDENTIFIED BY 'genericparser' WITH GRANT OPTION; -GRANT ALL PRIVILEGES ON mysql.* TO 'genericparser'@'%' IDENTIFIED BY 'genericparser' WITH GRANT OPTION; +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 genericparser.* TO 'genericparser'@'localhost' IDENTIFIED BY 'genericparser' WITH GRANT OPTION; -GRANT ALL PRIVILEGES ON mysql.* TO 'genericparser'@'localhost' IDENTIFIED BY 'genericparser' 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; |