1.mysql数据库创建及连接数据库用户配置:(参照官方文档
Connecting JIRA applications to MySQL
https://confluence.atlassian.com/adminjiraserver074/connecting-jira-applications-to-mysql-881683181.html )
1-1.创建jira数据库和连接数据库账号:
mysql> create database jira character set utf8 collate utf8_bin;
mysql> grant select,insert,update,delete,create,drop,alter,index on jira.* to 'jira'@'localhost' identified by 'crhcrh';
mysql> flush privileges;
查看授权是否成功:
[root@centos7 bin]# mysql -ujira -pcrhcrh
mysql> show grants for jira@localhost;
1-2.修改/etc/my.cnf
[mysqld]添加以下:
default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=256M
重启数据库。
1-3.copy the Mysql jdbc driver to application server
1-3-1.get the mysql driver
下载解压:tar -zxvf mysql-connector-java-5.1.44.tar.gz
1-3-2.copy the mysql jdbc driver jar to the <jira installation directory>/lib/ directory for your new/upgraded installation.
[root@centos7 lib]# pwd
/home/jira_home/lib
[root@centos7 lib]# cp /usr/local/src/mysql-connector-java-5.1.44/mysql-connector-java-5.1.44-bin.jar .
1-3-3.重启jira
2.安装jira(参考文档:
https://confluence.atlassian.com/adminjiraserver074/installing-jira-applications-on-linux-881683168.html)
2-1.[root@centos7 src]# ./atlassian-jira-software-7.4.3-x64.bin
安装选项:
Details on where JIRA Software will be installed and the settings that will be used.
Installation Directory: /home/jira_home
// this is where JIRA will be installed.
Home Directory: /usr/local/jirasoftdata
// this is where JIRA data like logs, search indexes and files will be stored.
HTTP Port: 8080
RMI Port: 8005
Install as service: Yes
浏览器访问:http://localhost:8080
2-2.配置jira
Choose
I'll set it up myself
.
2-3connect to database
2-3-1.第一步数据库mysql,已经准备好了,jira安装界面测试数据库连接:
3.jira配置和破解:
https://yq.aliyun.com/articles/141089
4.msql授权远程root连接数据库
GRANT ALL PRIVILEGES ON `jira`.* TO 'root'@'192.168.%.%' identified by 'mypwd' WITH GRANT OPTION;
flush privileges;