**
SpringBoot项目连接数据库时,报错:“java.sql.SQLException:== Access denied for user ‘root’@‘localhost’ (using password: YES)==”
**
报错的时候是这样写的
spring:
datasource:
username: root
password: 000
url: jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
1. 方法一:没有导入依赖
<!-- 添加MySQL依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!-- 添加JDBC依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
2. 方法二:application.yaml
数据源的password如果是数字需要用双引号,这样会识别
spring:
datasource:
username: root
password: "000"