SpringBoot项目连接数据库报错:
Access denied for user 'root'@'localhost' (using password: YES):
使用application.yml
配置文件:
这样访问时就会报错:
spring:
application:
name: common-item
datasource:
driverClassName: com.mysql.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/bzshop?useUnicode=true&characterEncoding=utf-8&useSSL=false
username: root
password: 0100
type: com.alibaba.druid.pool.DruidDataSource
![bdc35d2984971017c776eea1f19451d8.png](https://i-blog.csdnimg.cn/blog_migrate/e2bdd57ee5138ea5b11c8c9c5760afd0.jpeg)
正确的配置信息:
spring:
application:
name: common-item
datasource:
driverClassName: com.mysql.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/bzshop?useUnicode=true&characterEncoding=utf-8&useSSL=false
username: root
password: "0100"
type: com.alibaba.druid.pool.DruidDataSource
注意:
yml
是区分数据类型的,所以如果用户名或者密码是数字的话,就要小心了。所以如果password
为000000
的话,最终获取到的值是0
,显然不对,那么6
个0
怎么表示呢?只能用字符串"000000"
,这样获取到的密码就是正确的了!