diff options
Diffstat (limited to 'standalone/src/main/assembly/resources/dbscripts')
| -rw-r--r-- | standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql | 12 | ||||
| -rw-r--r-- | standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql | 2 |
2 files changed, 7 insertions, 7 deletions
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; -- ---------------------------- |