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
The Touchable Shop POS (Point of Sale) system is a sophisticated software solution developed using…
Creating a responsive login form is a crucial skill for any web developer. In this…
In this tutorial will teach Laravel 12 CRUD API by step. Laravel 10 CRUD Application …
In this lesson we talk about laravel 12 image uploading and display the image step…
In this tutorial will teach Laravel 12 CRUD Application step by step. Laravel 12 CRUD…
Conditional statements in Python allow us to control the flow of execution based on conditions.…