Creating a schema

We need a schema that we will use for our application. Create a schema called journaler_api with default UTF-8 collation. For this purpose, it is up to you how you will access the local MySQL server instance and create a schema. We will use MySQL Workbench, as shown in the following screenshot:

Review the SQL script, as shown in the following screenshot:

Apply the SQL script, as shown in the following screenshot:

Extending dependencies

To work with Spring Data JPA, open your build.gradle and extend it:

... 
dependencies { 
    ... 
    runtime('mysql:mysql-connector-java') 
    compile("org.springframework.boot:spring-boot-starter-data-jpa") 
    ... 
} 

We have provided the necessary dependencies and we have also added support for MySQL connector and Spring Data JPA. Next, what we need to do is to define our data source. Open the application.properties file and add configuration according to your local MySQL instance:

spring.datasource.url=jdbc:mysql://localhost/journaler_api...