创建mysql数据库:
CREATE DATABASE jiradb CHARACTER
SET 'UTF8';
创建mysql用户
CREATE USER jirauser IDENTIFIED BY 'jira';
GRANT ALL PRIVILEGES ON *.* TO 'jirauser' @'%' IDENTIFIED BY 'jira' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'jirauser' @'localhost' IDENTIFIED BY 'jira' WITH GRANT OPTION;
FLUSH PRIVILEGES;
将数据库排序规则由utf8_general_ci
改为utf8_bin或utf8mb4_bin(具体看版本)
停止jira服务
Windows: 运行JIRA安装目录下bin子目录中的config.bat
其它操作系统: 运行JIRA安装目录下bin子目录中的config.sh
配置数据库连接信息并测试连接
将mysql-connector-java的jar包放入lib文件夹
JIRA\lib
重启jira服务