diff options
author | shentao <shentao@chinamobile.com> | 2017-11-15 19:21:15 +0800 |
---|---|---|
committer | shentao <shentao@chinamobile.com> | 2017-11-15 19:21:22 +0800 |
commit | 919401afdaa375b8f3006186224c987841427123 (patch) | |
tree | 8b252ce24815e0576522f3e25b218555eb7c5816 | |
parent | d1274a88d001119c155a8dd4ed47c018553da9f0 (diff) |
Change database name for usecase-ui server
Change-Id: I3ff33b6364c2cf8eade1e6f7439dd176556e20f3
Issue-Id: USECASEUI-54
Signed-off-by: shentao <shentao@chinamobile.com>
3 files changed, 8 insertions, 8 deletions
diff --git a/server/src/main/resources/application.properties b/server/src/main/resources/application.properties index 3ffb4da7..c3470659 100644 --- a/server/src/main/resources/application.properties +++ b/server/src/main/resources/application.properties @@ -22,7 +22,7 @@ spring.http.multipart.max-request-size=128MB ## App DB Properties spring.datasource.url=jdbc:mysql://localhost:3306/uui spring.datasource.username=root -spring.datasource.password= +spring.datasource.password=root spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQLDialect spring.database.driver.classname=com.mysql.jdbc.Driver spring.jpa.show-sql=false diff --git a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql index 31ab5b5e..004a717a 100644 --- a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql +++ b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql @@ -16,16 +16,16 @@ /******************drop old database and user***************************/ use mysql; -drop database IF EXISTS usercaseui; +drop database IF EXISTS uui; delete from user where User='usecaseui'; FLUSH PRIVILEGES; /******************create new database and user***************************/ -create database usercaseui CHARACTER SET utf8; +create database uui CHARACTER SET utf8; -GRANT ALL PRIVILEGES ON usercaseui.* TO 'usercaseui'@'%' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION; -GRANT ALL PRIVILEGES ON mysql.* TO 'usercaseui'@'%' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON uui.* TO 'uui'@'%' IDENTIFIED BY 'uui' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON mysql.* TO 'uui'@'%' IDENTIFIED BY 'uui' WITH GRANT OPTION; -GRANT ALL PRIVILEGES ON usercaseui.* TO 'usercaseui'@'localhost' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION; -GRANT ALL PRIVILEGES ON mysql.* TO 'usercaseui'@'localhost' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON uui.* TO 'uui'@'localhost' IDENTIFIED BY 'uui' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON mysql.* TO 'uui'@'localhost' IDENTIFIED BY 'uui' WITH GRANT OPTION; FLUSH PRIVILEGES;
\ No newline at end of file diff --git a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql index fc1e08a3..1acf5833 100644 --- a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql +++ b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql @@ -14,7 +14,7 @@ -- limitations under the License. -- -use usercaseui; +use uui; SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- |