安装后的初始密码要能打印的my.cnf配置
[mysqld]
log_error=/var/log/mysqld.log
log_error_verbosity=2
general_log=NO
general_log_file=/var/log/mysql.log
查找初始密码
cat /var/log/mysqld.log |grep "temporary password"
修改本地root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '****';
FLUSH PRIVILEGES;
开放授权的权限
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root' AND host='%';
创建数据库与账号，并授权
create database confluence;
CREATE USER 'confluence'@'%' IDENTIFIED BY '*****';
GRANT ALL PRIVILEGES ON confluence.* TO 'confluence'@'%';
FLUSH PRIVILEGES;
confluence支持5.7的my.cnf配置
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
validate_password=OFF
character-set-server=utf8mb4
collation-server=utf8mb4_bin
default-storage-engine=INNODB
max_connections=200
plugin-load=validate_password.so
innodb_log_file_size=2GB
max_allowed_packet = 256M
transaction-isolation=READ-COMMITTED
binlog_format=row
log_bin_trust_function_creators = 1
optimizer_switch = derived_merge=off
confluence配置MySql数据库连接时，使用简单模式
数据库连接地址：jdbc:mysql://localhost:3306/confluence?useSSL=false
