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 have created a new database named jiradb and a new database user named jirauser. We will be using 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 in. 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, 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 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.

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:// host:8080. 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 the language JIRA will use for its user interface.

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 Next to move to the second step of the wizard as shown in the following screenshot:

Enter the title for this JIRA instance.

Select Public if you would like to let people sign up for accounts, or select Private if you want only administrators to create accounts. For most organizations that use JIRA to track internal projects, it will be the 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.

Select the I don't have an account option if you do not have a valid JIRA license and you do not have an account on my.atlassian.com.

Select the I have an account but no key option if you have an account on my.atlassian.com but you do not have a valid JIRA license key.

Select the I have a key option if you have a valid JIRA license key handy.

Click on Next to go to the fourth 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 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 if 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, as shown in the following screenshot: