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...