安装 MySQL 5.7

# 安装数据库
$ wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
$ yum localinstall mysql80-community-release-el7-3.noarch.rpm
$ yum-config-manager --disable mysql80-community
$ yum-config-manager --enable mysql57-community
$ yum makecache
$ yum install mysql-community-server
$ systemctl daemon-reload
$ systemctl enable mysqld.service
$ systemctl start mysqld.service
$ systemctl status mysqld.service
 
 
# 数据库用户 root 的初始密码
$ grep 'temporary password' /var/log/mysqld.log
2019-04-25T08:12:44.871268Z 1 [Note] A temporary password is generated for root@localhost: 0aoyv7_kjTty
 
 
# 修改数据库 root 用户密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'rootpassword';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
 
# https://confluence.atlassian.com/conf69/database-setup-for-mysql-950285439.html
# 创建相关数据库
mysql> CREATE DATABASE confluence CHARACTER SET utf8 COLLATE utf8_bin;
Query OK, 1 row affected (0.00 sec)
 
# 创建相关用户
mysql> GRANT ALL PRIVILEGES ON confluence.* TO 'confluence'@'*' IDENTIFIED BY 'confluencepassword';
Query OK, 0 rows affected, 1 warning (0.00 sec)
 
mysql>