Open up a new command prompt on the MySQL server.

Run the following command (you can also use another user instead of root as long as the user has permission to create new users and databases):

        mysql -u root -p

Enter the password for the user when prompted.

Create a new database for JIRA by running the following command:

        create database jiradb character set utf8;

Create a new user for JIRA in the database and grant the user access to the jiradb database we just created using the following command:

        grant all on jiradb.* to 'jirauser'@'localhost'
        identified by  'jirapassword';

In the previous five steps, we created a new database named jiradb and a new database user named jirauser. We will use these details later to connect JIRA with MySQL. The next step is to install JIRA.

Create a dedicated user account to run JIRA under. If you're using Linux, run the following command as root or with sudo:

        useradd --create-home --comment "Dedicated
        JIRA account" -- shell /bin/bash jira

Create a new directory on the filesystem where JIRA will be installed. This directory will be referred to as JIRA_INSTALL.

Create another directory on the filesystem. This will be used for JIRA to store its attachments, search indexes, application data, and other information. You can create this directory on a different drive with more hard disk capacity, such as a network drive (this could slow down the performance). This directory will be referred to as JIRA_HOME.

Unzip the JIRA archive file in the JIRA_INSTALL directory.

Change both the JIRA_INSTALL and JIRA_HOME directories' owner to the new JIRA user.

Open the JIRA_INSTALL/atlassian-jira/WEB-INF/classes/jira-application.properties file in a text editor.

Locate the jira.home= line in this file.

Cut and paste this in the full path to the JIRA_HOME directory and remove the # symbol if present. Make sure you use the forward slash (/). The following line shows how it looks on a Linux system:

        jira.home=/opt/data/jira_home 

Copy the database driver JAR file (obtained from the Getting ready section) to the JIRA_INSTALL/lib directory.

Start up JIRA by running the start-jira.sh (for Linux) or start-jira.bat (for Windows) script from the JIRA_INSTALL/bin directory as the JIRA user. You should see the output Tomcat started in your console; this means that JIRA is up and running.

JIRA comes with a setup wizard that will help guide us through the final phase of the installation.

Open up a browser and go to http://localhost:8080 (replace localhost with the actual server name). By default, JIRA runs on port 8080. You can change this by changing the connector port value in the JIRA_INSTALL/conf/server.xml file.

The first step is to select how you want JIRA to be set up. Select the I'll set it up myself option and click on the Next button.

The second step is to set up the database information. Select the My Own Database (recommended for production environments) option.

Select a value for the Database Type option. For this recipe, select the MySQL option.

Enter the details for our new jiradb database.

Click on Test Connection to check whether JIRA is able to connect to the database.

Click on the Next button to proceed if the database connection test is successful and move to the next step of the wizard.

Enter the Application title value for this JIRA instance.

Select Public if you would like to let people sign up for accounts or Private if you want only administrators to create accounts. For most organizations that use JIRA to track internal projects, this will be in Private mode.

Set the Base URL option. The base URL is the one that users will use to access JIRA. Usually, this should be a fully qualified domain name or the hostname—that is, not a localhost or an IP address.

Click on Next to go to the third step of the wizard, as shown in the following screenshot:

Enter your JIRA license key if you have one. If you do not have a license key, you can generate a temporary trial license by visiting https://my.atlassian.com and creating an account.

Click on Next to go to the next step of the wizard, as shown in the following screenshot:

Enter the details for the initial administrator account. The user account will have access to all the configuration options in JIRA, so make sure you do not lose its login credentials.

Click on Next to go to the fifth and final step of the wizard, as shown in the following screenshot:

Choose whether you want to set up an outgoing SMTP server Now or Later. If you do not have an SMTP server ready right now, you can always come back and configure it later.

Click on Finish to complete the setup process.