Spring Boot Connect to MySQL Database Example

Learn how to configure a Spring Boot application to connect to MySQL database server in two kinds of applications:
– Spring Boot console program with JdbcTemplate
– Spring boot webapp with Spring Data JPA

How to configure Data Source Properties for a Spring Boot project?
– JDBC url, username & password
– JDBC Driver class name
– Database dialect class (Hibernate)
– Show & Format SQL statements (Hibernate)
– DDL Auto (Hibernate)

Software programs:
– Java Development Kit (JDK)
– Spring Tool Suite IDE (STS)
– MySQL Community server & MySQL Workbench