Packt+ | Advance your knowledge in tech

You're reading from Mastering JIRA 7 Become an expert at using JIRA 7 through this one-stop guide!

Product type Paperback

Published in Oct 2016

Publisher Packt

ISBN-13 9781786466860

Length 450 pages

Edition 2nd Edition

Languages

Java

Tools

JIRA

Concepts

Project Management

Author (1):

Ravi Sagar

View More author details

Table of Contents (25) Chapters

Mastering JIRA 7 - Second Edition

Credits

About the Author

Acknowledgements

About the Reviewer

www.PacktPub.com

Preface

1. Planning Your JIRA Installation

2. Searching in JIRA FREE CHAPTER

3. Reporting – Using Charts to Visualize the Data

4. Customizing JIRA for Test Management

5. Understanding Zephyr and its Features

6. Sample Implementation of Use Cases

7. User Management, Groups, and Project Roles

8. Configuring JIRA User Directories to Connect with LDAP, Crowd, and JIRA User Server

9. JIRA Add-On Development and Leveraging the REST API

10. Importing and Exporting Data in JIRA and Migrating Configuration

11. Working with Agile Boards in JIRA Software

12. JIRA Administration with ScriptRunner and the CLI Add-on

13. Database Access

14. Customizing Look, Feel, and Behavior

15. Implementing JIRA Service Desk

16. Integrating JIRA with Common Atlassian Applications and Other Tools

17. JIRA Best Practices

18. Troubleshooting JIRA

Accessing MySQL

The HSQL Database Manager should never be used in the production instance because it's prone to data loss. The recommended database is either MySQL or PostgreSQL. Earlier in this book, we discussed how to create a database in MySQL to store JIRA's data and configure it during the setup phase. To access your database in order to run SQL queries, you can either use the MySQL console, which comes with the MySQL server, or you can use phpMyAdmin.

phpMyAdmin

The phpMyAdmin application can be downloaded from http://www.phpmyadmin.net/.

This is a great web-based tool to manage your MySQL database and it's usually accessed using http://localhost/phpmyadmin/. The exact URL can be different, depending on your installation.

Perform these following steps:

Open the previous URL in your browser to launch phpMyAdmin:

You will notice that the list of databases appears on the left-hand side. Our jiradb database also appears in this list. We created this database for our JIRA instance.
Click on...