In this tutorials will discuss the how to configure the MySQL database with Spring Boot Intellij Idea.will do it step by step.
application.properties
spring.application.name=FirstApp server.port=8088 spring.jpa.hibernate.ddl-auto=update spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3306/school?createDatabaseIfNotExist=true spring.datasource.username=root spring.datasource.password=root #jpa vendor adapter configuration spring.jpa.database-platform=org.hibernate.dialect.MySQL57Dialect spring.jpa.generate-ddl=true spring.jpa.show-sql=true
In this application.properties we have to get all the database connectivity details here
spring.datasource.url=jdbc:mysql://localhost:3306/school?createDatabaseIfNotExist=true spring.datasource.username=root spring.datasource.password=root
add them in to the database configuration dialog.
This is the dialog where you configure the database connectivity.
Host : localhost
Port : you have to give the port which port you given on the application.properties of Spring boot project. In this example gave as 3306.
Username : root
password : root
database name: school
if you enter all the details and apply. and run the project you can see one the console your database and table is creating.
then open up the database tree you can see the database and tables
i have attached the video link below. which will do this tutorials step by step
