连接信息配置错误
SpringBoot项目连接数据库报错:Access denied for user 'root'@'localhost' (using password: YES)
reate connection SQLException, url: jdbc:mysql://localhost:3306/ebook, errorCode 1045, state 28000
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[mysql-connector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) ~[mysql-connector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) ~[mysql-connector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871) ~[mysql-connector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714) ~[mysql-connector-java-5.1.47.jar:5.1.47]
SpringBoot项目配置文件有两种格式,常用的application-xx.properties和最新的application-xx.yml。
运行项目时常常出现以上错误。一般是两个原因导致的:要么是连接信息配置错误,要么就是数据库未授权。
properties方式配置的话,只要填写正确的用户名和密码,就可以了,但是yml配置会出现一些错误;
如下:
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&useSSL=false
username: root
password: 012345
正确表示:
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&useSSL=false
username: root
password: "012345"
yml是区分数据类型的,所以如果用户名或者密码是数字的话就会出错。所以如果password为012345的话,最终获取到的值是12345,这样是不对的,只能用字符串"012345",才能正确表示。