Setting up a MariaDB database

Now, we will switch our database from H2 to MariaDB. The database tables are still created automatically by JPA. However, before we run our application, we have to create a database for it. In this section, we will be using the one-to-many relationship from the previous section.

The database can be created by using HeidiSQL. Open HeidiSQL and follow these steps:

1. Right-click inside the database list.
2. Then, select Create new | Database:

Figure 3.19 – Create new – Database

3. Let's name our database cardb. After clicking OK, you should see the new cardb database in the database list:

Figure 3.20 – The cardb database

4. In Spring Boot, add a MariaDB Java client dependency to the pom.xml file and remove the H2 dependency since we don't need it anymore:

   <dependency>
       <groupId>org.mariadb.jdbc</groupId>
     ...