Steps to connecting JIRA with MySQL

By Anuket Jain On 28 June 2015 In Home, Linux

The JIRA Setup Wizard helps you configure the basic settings for your new JIRA server. These include the server language, database, license key, administrator accounts and mail notifications.

This article will help you to configure connectivity between JIRA and MySQL.

Configure the MySQL database

Create a database user for JIRA using following comamnd:

mysql> CREATE USER '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>';

Example:

mysql> CREATE USER 'jirauser'@'localhost' IDENTIFIED BY 'jirapassword';

Create a database for JIRA and Ensure that the user has permission to connect to the database. These can be provided with the following:

mysql> CREATE DATABASE <DATABASE_NAME>
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on <DATABASE_NAME>.* TO '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>';
mysql> flush privileges;

Copy the MySQL JDBC driver to your application server

Copy the MySQL JDBC driver to your Jira server

Download MySQL Connector
If you are installing JIRA, we require MySQL Connector driver. You can download either the .tar.gz or the .zip file by selecting the ‘Platform Independent’ option. Download latest recommended MySQL Connector driver from official site:
Either you can download using following command:

# cd /opt
# wget http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.35.tar.gz

Extract the archive file using following command:

# tar -zxvf mysql-connector-java-5.1.35.tar.gz

Copy MySQL Driver
Copy the MySQL JDBC driver jar file to the JIRA installation directory. Use follow steps to copy the JDBC driver:

# cd /opt/mysql-connector-java-5.1.35
# cp mysql-connector-java-5.1.35-bin.jar /opt/atlassian/jira/lib/

Restart Jira Service
Restart JIRA service using following command:

# cd /opt/atlassian/jira/bin/
# ./shutdown.sh
# ./startup.sh

Comments

9 years ago
Rik March 4, 2016
Thank you very much. I was searching where to install the MySQL connector.
Now i know i have to copy the mysql-connector-java–bin.jar to /opt/atlassian/jira/bin/
Cheers!
ps. CREATE DATABASE should end with an ; ofcourse.
Reply
9 years ago
makeIT April 11, 2016
Right command for copy would be:
# cd /opt/mysql-connector-java-5.1.35
# cp mysql-connector-java-5.1.35-bin.jar /opt/atlassian/jira/lib/
Otherwise you will have error:
Could not find driver with class name: com.mysql.jdbc.Driver
Reply
- 9 years ago
  Dennis R April 11, 2016
  Yes right,
  Thanks
  Reply