JIRA Server Administration - JIRA 6.x Administration Topic - page 5

How to do it…
We first need to create an empty MySQL database for JIRA:
1. Open up a new command prompt on the MySQL server.
2. 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
3. Enter the password for the user when prompted.
4. Create a new database for JIRA by running the following command:
create database jiradb character set utf8;
5. 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 con-
nect JIRA with MySQL. The next step is to install JIRA.
6. 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
Note
It is a good practice to reduce security risks by locking down the user account so
that it does not have login permissions.
7. Create a new directory on the filesystem where JIRA will be installed in. This dir-
ectory will be referred to as JIRA_INSTALL .
8. 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