Book Image

Mastering JIRA 7 - Second Edition

By : Ravi Sagar
Book Image

Mastering JIRA 7 - Second Edition

By: Ravi Sagar

Overview of this book

Atlassian JIRA 7 is an enterprise issue tracker system. One of its key strengths is its ability to adapt to the needs of an organization, ranging from building software products to managing your support issues. This book provides a comprehensive explanation covering all three components of JIRA 7, such as JIRA Software, JIRA Core, and Jira Service Desk. It shows you how to master the key functionalities of JIRA and its customizations and useful add-ons, and is packed with real-world examples and use cases. You will first learn how to plan for a JIRA 7 installation and fetch data. We cover JIRA reports in detail, which will help you analyze your data effectively. You can add additional features to your JIRA application by choosing one of the already built-in add-ons or building a new one to suit your needs. Then you'll find out about implementing Agile methodologies in JIRA by creating Scrum and Kanban boards. We'll teach you how to integrate your JIRA Application with other tools such as Confluence, SVN, Git, and more, which will help you extend your application. Finally, we'll explore best practices and troubleshooting techniques to help you find out what went wrong and understand how to fix it.
Table of Contents (25 chapters)
Mastering JIRA 7 - Second Edition
About the Author
About the Reviewer

Setting up the MySQL database

JIRA needs to store its data in a database. For this, we will set up a MySQL database. JIRA 7 requires MySQL 5.1 up until 5.6 to run smoothly. You should refer to the preferred MySQL server configurations as described on the following page:

It's also possible to use PostgreSQL, Oracle, or Microsoft SQL Server with JIRA, but here we will discuss how to set up the MySQL database:

  1. Log in to your MySQL Server with the following command:

    mysql -u root -p
  2. Enter the password.

  3. Create a new database to be used by JIRA using the following command:

    Create database jiradb character set utf8 COLLATE utf8_bin;
  4. Create a new user and give it permissions on the database:

            INDEX on jiradb.* TO 
            'jirauser'@'localhost' IDENTIFIED BY 'password';
  5. Flush the privileges using the following command:

    flush privileges;

We have created a MySQL database name as jiradb, a database username as jirauser, and a database password as password. Keep this information on hand because we will need it when we set up JIRA.


To use MySQL with JIRA, you need to download a mysql-connector-java-5.1.32-bin.jar database driver and copy it to the lib folder under JIRA's installation directory. The driver can be downloaded from