Spring boot

Spring boot Mysql Database configuration

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

 

 

 

 

 

 

admin

Recent Posts

Touchable shop Pos system using Java

The Touchable Shop POS (Point of Sale) system is a sophisticated software solution developed using…

2 weeks ago

Build Your First Responsive Login Form Using HTML and CSS FlexBox

Creating a responsive login form is a crucial skill for any web developer. In this…

3 weeks ago

Build Crud API with Laravel 12

In this tutorial will teach  Laravel 12 CRUD API  by step. Laravel  10 CRUD Application …

3 weeks ago

laravel 12 image upload tutorial

In this lesson we talk about laravel 12 image uploading and display the image step…

4 weeks ago

Laravel 12 CRUD Application

In this tutorial will teach Laravel 12 CRUD Application step by step. Laravel  12 CRUD…

1 month ago

Conditional Statements in Python

Conditional statements in Python allow us to control the flow of execution based on conditions.…

2 months ago