安装 Confluence6.7.1
我是使用命令行进入mysql的mysql -uroot -p123456
创建数据库
CREATE DATABASE confluence DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
如果已创建数据库,修改编码格式
ALTER DATABASE confluence DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
check编码格式
SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA S
WHERE schema_name = 'confluence'
AND
(
DEFAULT_CHARACTER_SET_NAME != 'utf8'
OR
DEFAULT_COLLATION_NAME != 'utf8_bin'
);
fix 数据库链接
jdbc:mysql://localhost:3306/confluence?sessionVariables=tx_isolation='READ-COMMITTED'&useUnicode=true&characterEncoding=utf8