diff options
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; |