JIRA needs to store its data in a database. For this, we will set up a MySQL database. It's also possible to use PostgreSQL, Oracle, or Microsoft SQL Server with JIRA:
Log in to your MySQL Server with the following command:
mysql –u root –pEnter the password.
Create a new database to be used by JIRA using the following command:
Create database jiradb character set utf8;Create a new user and give it permissions on the database:
GRANT SELECT,INSERT, UPDATE,DELETE,DROP,CREATE,ALTER,INDEX on jiradb.* TO 'jirauser'@'localhost' IDENTIFIED BY 'password';Flush the privileges using the following command:
flush privileges;
We have created a MySQL database name as jiradb, database username as jirauser, and database password as password. Keep this information at hand because we will need it when we set up JIRA.
Note
To use MySQL with JIRA, you need to download a mysql-connector-java-5.1.32-bin database driver and copy it to the lib folder under JIRA's installation directory. The driver can be downloaded from http://dev.mysql.com/downloads/connector/j.