Now that you have MySQL installed, you need to create a user for Jira to connect MySQL with as you should never use the default root user, and then create a fresh database for Jira to store all its data:
- Start the MySQL Command Line Client by navigating to Start | All Programs | MySQL | MySQL Server 5.7 | MySQL 5.7 Command Line Client.
- Enter the MySQL root user password you set during installation.
- Use the following command to create a database:
create database jiradb character set utf8;
- Here, we are creating a database called jiradb. You can name the database anything you like. As you will see later in this chapter, this name will be referenced when you connect JIRA to MySQL. We have also set the database to ...