As root download the installer.
`wget https://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-software-8.14.0-x64.bin`
create user 'jira'@'%' IDENTIFIED BY '<password>';
create user 'jira' identified by '<password>';
create database jiradb character set utf8mb4 collate utf8mb4_bin;
grant select,insert,update,delete,create,drop,references,alter,index on jiradb.* to 'jira'@'%';
flush privileges;
grant all on `jiradb`.* to 'jira'@'localhost';
Create file /etc/mysql/mysql.conf.d/jira.mysqld.cnf with the following content.
[mysqld]
default-storage-engine=INNODB
; Specify the character set used by the database server:
character_set_server=utf8mb4
; Set the default row format to DYNAMIC:
innodb_default_row_format=DYNAMIC
; Specify the value of innodb_log_file_size to be at least 2G:
innodb_log_file_size=2G
; Ensure the sql_mode parameter does not specify NO_AUTO_VALUE_ON_ZERO
sql_mode = NO_AUTO_VALUE_ON_ZERO
Restart mysql to have it effect systemctl restart mysql.
Install the Ubuntu Debian package.
wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-j_8.0.31-1ubuntu20.04_all.deb
dpkg -i mysql-connector-j_8.0.31-1ubuntu20.04_all.deb
Create a symlink in the /opt/atlassian/jira/lib directory of the installed jar-file.
ln -s /usr/share/java/mysql-connector-j-8.0.31.jar /opt/atlassian/jira/lib/mysql-connector-j-8.0.31.jar
Restart jira servive (very old style) for the driver to have effect.
/etc/init.d/jira stop
/etc/init.d/jira start