Auto database creation springboot and mysql

Question

I am trying create mysql database when application starts up. I have tried with bellow configuration but could not able to achieve, Please let me know if anybody have idea about this,

spring.jpa.hibernate.ddl-auto=none
spring.datasource.initialization-mode=always
spring.jpa.properties.hibernate.globally_quoted_identifiers=true

Are you looking for something like creating schema automatically if not exists? — Alien
– Alien, Commented Dec 5, 2018 at 10:28
Please use below link for reference. stackoverflow.com/questions/26881739/… — Sushant
– Sushant, Commented Dec 5, 2018 at 10:30

Alien · Accepted Answer · 2018-12-05 10:33:16Z

6

If you are looking for to create database if not exists then you can use below in database configuration file.

jdbc:mysql://localhost:3306/dbname?createDatabaseIfNotExist=true

Otherwise make sure you have below properties in your application properties file.

spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
spring.jpa.hibernate.ddl-auto=update
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/dbname
spring.datasource.username=username
spring.datasource.password=password

answered Dec 5, 2018 at 10:33

Alien

16k8 gold badges43 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

NiVeR · Accepted Answer · 2018-12-05 10:33:16Z

0

You should be setting the property with a value that actually creates the schema, for instance:

spring.jpa.hibernate.ddl-auto=create-drop

You may find a more detailed reference here.

answered Dec 5, 2018 at 10:33

NiVeR

9,8064 gold badges33 silver badges36 bronze badges

Comments

Procrastinator · Accepted Answer · 2022-06-14 06:44:14Z

0

I have added the following option:

"createDatabaseIfNotExist=true"
spring.datasource.url=jdbc:mysql://localhost:3306/"DB_NAME"?createDatabaseIfNotExist=true

edited Jun 14, 2022 at 6:44

Procrastinator

2,67445 gold badges31 silver badges37 bronze badges

answered Jun 11, 2022 at 5:26

Nick Skorobahatyi

373 bronze badges

Collectives™ on Stack Overflow

Auto database creation springboot and mysql

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related