jdbc mysql自动创建数据库_自动创建数据库springboot和mysql

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

解决方案

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