Jira 8 Administration Cookbook - Third Edition

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';

6. In the previous five steps, we created a new database named jiradb and a new database ...