--创建jira数据库及用户 create database jiradb character set 'UTF8'; create user jirauser identified by 'jira'; grant all privileges on *.* to 'jirauser'@'%' identified by 'jira' with grant option; grant all privileges on *.* to 'jirauser'@'localhost' identified by 'jira' with grant option; flush privileges;
--创建confluence数据库及用户 create database confdb character set 'UTF8'; create user confuser identified by 'conf'; grant all privileges on *.* to 'confuser'@'%' identified by 'conf' with grant option; grant all privileges on *.* to 'confuser'@'localhost' identified by 'conf' with grant option; flush privileges;
-- 设置confdb事务级别 show variables like 'tx%'; set session transaction isolation level read committed; show variables like 'tx%';