confluence MySQL配置
#confluence
character-set-server=utf8mb4
collation-server=utf8mb4_bin
default-storage-engine=INNODB
max_allowed_packet=256M
transaction-isolation=READ-COMMITTED
binlog_format=row
log_bin_trust_function_creators = 1
创建数据库授权:
CREATE DATABASE confluence CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
create user 'confluenceuser'@'localhost' IDENTIFIED BY 'xxx';
grant all privileges on confluence.* TO 'confluenceuser'@'localhost' with grant option;
mysql配置报错:
You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
修改mysql参数:
[mysqld]
log_bin_trust_function_creators = 1
中文乱码
文档使用宏编辑并发布后,不能够正常显示中文格式。
#1.创建中文字体目录
mkdir /usr/share/fonts/chinese
#2上传本地windows的黑体字体 simhei.ttf 文件至/usr/share/fonts/chinese目录下即可
#3.修改目录的极跟
chmod -R 755 /usr/share/fonts/chinese
#4.修改/bin/setenv.sh:增加以下语甸
CATALINA OPTS="-Dfile.encoding=UTF-8 ${CATALINA_OPTS}"
评论区