39- Configuring MySQL for project

 

Before Configuring database we need to execute a query in MySql Workbench to Create database

create database sms;   

Now ,

Configuring MySQL Database using jdbc and hibernate

(username and password depends on MySQL Worbench of user)

student-management-system -->  src/main/resources -->  application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/sms?useSSL=false & serverTimezone=UTC & useLegacyDateTimeCode=false

spring.datasource.username=root

spring.datasource.password=root

#Hibernate

spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

#create,create-drop

spring.jpa.hibernate.ddl-auto=update

logging.level.org.hibernate.SQL= DEBUG