Steps to connecting JIRA with MySQL

Share It!

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.

Jira with 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
    1. 1 year ago
    2. 12 months ago
      • 12 months ago

    Leave a Reply

    Your email address will not be published.