Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.

Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.#

无法配置DataSource：未指定'url'属性，也无法配置嵌入数据源

解决方法一#

在application.properties中配置在application.properties文件中

#数据库相关配置
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/sql_test
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.max-idle=10
spring.datasource.max-wait=10000
spring.datasource.min-idle=5
spring.datasource.initial-size=5

解决方法二 #

启动类头部声明就可以了

@SpringBootApplication(exclude= {DataSourceAutoConfiguration.class})