# 这是mysql5.7上的
create database confluence default character set utf8 collate utf8_bin;
grant all on confluence.* to 'confluence'@'%' identified by 'confluence';
grant all on confluence.* to confluence@"localhost" identified by "confluence";
SET GLOBAL tx_isolation='READ-COMMITTED';
FLUSH PRIVILEGES;
#这是mysql8.0上的
# 创建confluence数据库
CREATE DATABASE confluence CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
# 创建confluenceuser用户,密码是confluence
CREATE USER 'confluence'@'localhost' IDENTIFIED BY 'confluence';
# 赋予数据库用户权限
GRANT ALL PRIVILEGES ON confluence.* TO 'confluence'@'localhost';