Home
MySQL Configuration with Spring Boot
August 4, 2016
No Comments

MySQL Configuration with Spring Boot

Hello friends as we have already discussed in the previous chapter about how you in memory database or embedded database of Spring Boot like H2, HSQL etc. Out of the box, Spring Boot is very easy to use with the H2 or HSQL Database. If the HSQL database is found on your classpath, Spring Boot will automatically set up an in memory HSQL database for your use., I have used in-memory databases like HSQL for persisting data. But, these in-memory databases cannot be used for the production. These are only used for the development environment. But what if you want to use MySQL? Naturally, Spring Boot has support for MySQL and a number of other popular relational databases.
Let’s see we want to deploy this application to production and we’ve decided to use MySQL for the database. Changing Spring Boot from HSQL to MySQL is easy to do.

 Maven Configurations for MySQL Dependencies

<dependency>
 <groupId>mysql</groupId>
 <artifactId>mysql-connector-java</artifactId>
</dependency>
Here in the maven’s pom.xml, you just added mysql connector. Once this is added to the classpath, Spring Boot will automatically search for the MySQL configurations and use it.

MySQL Configuration

You’ll need to have a database defined for your use. For this example, I want to create a database for my use. Using the command prompt, you can log into MySQL with this command:
mysql -u root
Use the following command to create a database.
CREATE DATABASE dojdb;
There are following property we have to add the application property file application.properties and also we have to install MySQL DB at your machine firstly and after that you can go ahead with MySQL configuration.
spring.datasource.url=jdbc:mysql://localhost:3306/dojdb
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
If you are using ORM (Hibernate) with this application then we can add one more property in the file.
spring.jpa.hibernate.ddl-auto=create-drop
If this was actually a production database, you not tell Hibernate to use the create-drop option. This tells Hibernate to recreate the database on startup. Definitely not the behavior we want. You can set this property to the following values: none, validate, update, create-drop. If this was actually a production database, you probably would want to use validate.

 Summary

This is all about how to use and configure MySQL database with Spring Boot application and discussed all that needs to be changed to use MySQL with Spring Boot. When you start the project now, MySQL will be used by the Spring Boot application for the database.

Happy Spring Boot Learning!!!

Previous
Next
Spring Boot

Related Posts

About The Author

Dinesh Rajput

Dinesh Rajput is the chief editor of a website Dineshonjava, a technical blog dedicated to the Spring and Java technologies. It has a series of articles related to Java technologies. Dinesh has been a Spring enthusiast since 2008 and is a Pivotal Certified Spring Professional, an author of a book Spring 5 Design Pattern, and a blogger. He has more than 10 years of experience with different aspects of Spring and Java design and development. His core expertise lies in the latest version of Spring Framework, Spring Boot, Spring Security, creating REST APIs, Microservice Architecture, Reactive Pattern, Spring AOP, Design Patterns, Struts, Hibernate, Web Services, Spring Batch, Cassandra, MongoDB, and Web Application Design and Architecture. He is currently working as a technology manager at a leading product and web development company. He worked as a developer and tech lead at the Bennett, Coleman & Co. Ltd and was the first developer in his previous company, Paytm. Dinesh is passionate about the latest Java technologies and loves to write technical blogs related to it. He is a very active member of the Java and Spring community on different forums. When it comes to the Spring Framework and Java, Dinesh tops the list!