在centos7.5安装Jira数据库使用mysql5.7_mysql5.7是否支持jira-CSDN博客

本文介绍了如何在CentOS7.5系统中安装Jira并使用MySQL5.7作为数据库。首先，详细阐述了安装MySQL的过程，包括安装、创建数据库和用户以及重启服务。接着，讲解了Jira的安装步骤，从修改安装文件权限到设置Jira，包括选择自定义设置、连接到自己的数据库、输入数据库连接信息、测试连接、设置应用属性、输入许可证以及创建管理员账户。最后，提到了邮件提醒的配置，并提供了官方参考资料链接。

在centos7.5安装Jira数据库使用mysql5.7

- - - - 安装mysql
      - 安装Jira

安装mysql

1.安装过程点这里.
2.创建数据库以及数据库用户

//创建数据库（数据库必须有UTF8的字符集。要设置它，请在MySQL命令客户端中输入以下命令）
CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

//创建用户，这里我建的用户是jiralogin 如果mysql和jira不在一个服务器上这里的localhost需换成jira服务器的ip地址。密码为1234
create user 'jiralogin'@'localhost' identified by '1234';

//确保用户具有连接到数据库的权限，以及创建和填充表的权限。可以使用以下命令提供这些权限。
//MySQL 5.7.0 - 5.7.5:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on jiradb.* TO 'jiralogin'@'localhost' IDENTIFIED BY '1234';
flush privileges;

//MySQL 5.7.6 and later (must also include the REFERENCES permission):

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb.* TO 'jiralogin'@'localhost' IDENTIFIED BY '1234';
flush privileges;

3.重启mysql

service mysqld stop

4.拷贝MySQL JDBC driver
方法点这里

安装Jira

1.Install a Jira application

（1） Make the installer executable.（使安装文件可以执行，修改权限）

        chmod a+x atlassian-jira-software-8.13.2-x64.bin

（2）运行installer

        sudo ./atlassian-jira-software-8.13.2-x64.bin

    Follow the prompts to install Jira. You'll be asked for the following info:

    • Install type– choose option 2 (custom) for the most control. 

    • Destination directory –where Jira will be installed. /opt/inno/jira_software

    • Home directory – this is where Jira data like logs, search indexes and files will be stored.

    • TCP ports – these are the HTTP connector port and control port Jira will run on. Stick with the default unless you're running another application on the same port.

    这里因为8080已经被占用所以选择      HTTP Port Number[8100]、Control Port Number[8015]

    • Install as service – this option is only available if you ran the installer as sudo.
        Once installation is complete head to http://localhost:8100 in your browser to begin the setup process.
       
 这里做完以后就可以通过浏览器登录http://localhost:8100啦！

3.设置你的Jira 程序

（1) Choose set up method（选择设置方法）
Choose I’ll set it up myself.
（2) Connect to your database
Choose My own database.
（3) 填数据库的信息
Database Connection My Own Database

Database Type	Microsoft SQL Server
Hostname	localhost
Port	3306
Database	jiradb
Username	jiralogin
Password	1234

（4）测试数据库可否连接，可以的话进行下一步。
（5）Set application properties

Give your Jira site a name.

Choose whether your site should be private or anyone can sign up. You can change this later. 

Enter your base URL - this is the address people will use to access your Jira site.

（6）输入许可证
（7）创建admin账户
（8邮件提醒没设，到这里基本就没啥问题了）

参考资料：
https://confluence.atlassian.com/adminjiraserver/installing-jira-applications-on-linux-938846841.html