场景:
使用mybatis-plus和SpringBoot,用Druid连接,查询数据库时出现异常 用户访问被拒绝
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
在application.yml中核对过用户名密码后发现连接数据库密码是正确的,问题出在哪儿呢?
appliation.yml
点击查看applicatiion.yml代码
spring:
application:
name: aaaaa
datasource:
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/mptestbbb?serverTimezone=UTC
username: root
password: 1234
解决:
因为yml对数据类型有一定的要求,故如果你的密码是数字的话,就可能造成yml解析错误,进而导致数据库密码错误问题
应改为:
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/mptestbbb?serverTimezone=UTC
username: root
password: "1234"
只要把password的值用双引号引起来,问题便可得以解决
- 39 SQLException localhost password Access39 sqlexception localhost password 39 localhost password access localhost password access denied localhost password密码access 39 localhost password密码 39 localhost password错误 39 password access denied 39 localhost access denied localhost password方法access sqlexception connection localhost错误