springBoot Bug记录:java.sql.SQLException: Access denied for user 'root'@'localhost'

最新推荐文章于 2023-11-22 09:25:09 发布
最新推荐文章于 2023-11-22 09:25:09 发布
阅读量1.5k 收藏 4
点赞数 5
分类专栏： Bug库 springBoot 文章标签： java
一树一叶皆为木，一语一言皆由心。
本文链接：https://blog.csdn.net/justwanfeng/article/details/105506238
版权

文章目录

今天在写springBoot连接数据库的时候遇到一个bug,故写此贴记录一下解决方法
开发环境：

JDK:1.8
MAVEN:3.5.4
IDEA:2019.3
SpringBoot:2.2.6

问题描述:使用 application.properties配置连接数据库正常连接,而使用application.yml连接数据库报错:
报错内容:java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-3.4.2.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354) ~[HikariCP-3.4.2.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202) ~[HikariCP-3.4.2.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473) ~[HikariCP-3.4.2.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:554) ~[HikariCP-3.4.2.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[HikariCP-3.4.2.jar:na]
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-3.4.2.jar:na]
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:264) ~[spring-jdbc-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400) ~[spring-tx-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:572) ~[spring-tx-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:360) ~[spring-tx-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) ~[spring-tx-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at com.example.springboot_ssm_1.service.UserService$$EnhancerBySpringCGLIB$$38761da0.getAll(<generated>) ~[classes/:na]
	at com.example.springboot_ssm_1.controller.UserController.getAll(UserController.java:17) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_144]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_144]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_144]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_144]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879) ~[spring-webmvc-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793) ~[spring-webmvc-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.33.jar:9.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_144]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_144]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.33.jar:9.0.33]
	at java.lang.Thread.run(Thread.java:748) [na:1.8.0_144]
解决办法:yml中password对应的值用单引号引住

在这里插入图片描述

晚风_Join
关注
  • 5
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 8
    评论
专栏目录
记录因为yml而产生的坑：java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
01-19
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) 提示的是用户访问被拒绝，原因是密码不正确，但是我们明明配置的是正确的密码，原因就在yml中： spring: datasource: ...
java.sql.SQLException: 结果集已耗尽
08-02
NULL 博文链接：https://listen-raining.iteye.com/blog/1962065
MySQL8.0报错：java.sql.SQLException: Access denied for user ‘‘@‘localhost‘ (using password: YES)
桃花er的博客
03-18 842
原因：配置文件里 user=root password=123456 url=jdbc:mysql://localhost:3306/数据库名?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true driverClass=com.mysql.cj.jdbc.Driver initialSize=5
解决java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
热门推荐
Jonny_Wang的博客
04-15 7万+
mysql 5.7.17 数据库拒绝访问
SpringBoot项目连接数据库时，报错：“java.sql.SQLException:== Access denied for user ‘root‘@‘localhost‘ (using pa
思祺班Java
04-04 1247
** 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&
SpringBoot项目 java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
凌咚的博客
03-10 1094
​ 虽然SpringBoot帮我们做了许多工作，但是不明白内部原理极其容易出错，作为初学者应该稳扎稳打，理解底层原理。作为一位SpringBoot的初学者，学时尚浅，如有错误欢迎指出。​ 成功解决问题，这个问题比较特殊，一般数据库密码不可能纯数字，因此企业开发中基本不会遇到。​ 为了防止密码或者用户名解析为数值类型，将解决措施将。并且数据库密码是全数字，并且以。会被解析成八进制数值，就是十进制的。，解析为字符串类型，防止错误解析。文件的读取方式导致的密码错误，来读取不同进制的数值类型，例如。
springboot连接mysql的BUG：Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost'
qq_37023928的博客
05-09 890
我使用的是mysql8： Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) 配置： # 数据源配置 spring: datasource: type: com.alibaba.druid.pool.DruidDataSource driverClassName: com.mysql.cj.jdbc.Driver
springboot java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
qq_39397165的博客
12-14 386
前言 今天学习使用Spring配置Druid数据源的时候，连接数据库配到如下问题： pringboot java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO) 谷歌搜索了一下，发现导致这个问题出现的原因很多，按照每个都进行了检查，发现仍然没有解决，最后，才发现是我配置文件有问题，下面详细解...
MySQL存储表情时报错：java.sql.SQLException: Incorrect string value:‘\xF0\x9F\x92\xA9\x0D\x0A…’的解决方法
12-16
本文主要介绍了关于MySQL存储表情报错：java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x92\xA9\x0D\x0A…’的相关解决方法，分享出供大家参考学习，下面话不多说了，来一起看看详细的介绍： ...
MySQL存储表情时报错：java.sql.SQLException: Incorrect string value:‘\xF0\x9F\x92\xA9\x0D\x0A...’的解决方法
08-27
主要给大家介绍了关于MySQL存储表情时报错：java.sql.SQLException: Incorrect string value: 'xF0x9Fx92xA9x0Dx0A...'的解决方法，文中通过示例代码介绍的非常详细，需要的朋友可以参考借鉴，下面来一起看看吧。
异常：java.sql.SQLException: The server time zone value ‘?й???????’ is unrecognized or represents more
12-14
异常错误：java.sql.SQLException: The server time zone value ‘?й???’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTime...
报错：java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
最新发布
m0_73706260的博客
11-22 2538
因为yml或yaml对数据类型有一定要求，所以，如果你的密码是数字的话，就可能造成yml或yaml解析错误，从而导致数据库密码错误问题。
spring boot 项目启动报错：SQLException： Access denied for user 'root'@'localhost' (using password:YES）
weixin_46075653的博客
04-10 2532
spring boot 项目启动报错：java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES) 今天在学习过程中，遇到这么一个问题，之前没碰到过，在此记录一下。 spring boot 项目启动中报错：java.sql.SQLException: Access denied for ...
关于springboot布置项目报错### SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
weixin_45869839的博客
12-04 669
笔者发现这是因为你的yaml中的jdbc中配置出了问题 我的配置中mysql的密码是纯数字0818 他会被解析为其他的数字你只要吧password ：xxxx（你的密码）改为 password： " xxxx"即可 这是我电脑报错的代码:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error quer.
SpringBoot连接数据库报错java.sql.SQLException: Access denied for user ‘root‘@‘192.168.10.1‘ (using password
weixin_59371977的博客
02-05 613
SpringBoot连接数据库时循环报错java.sql.SQLException: Access denied for user 'root'@'192.168.10.1' (using password
Caused by: java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
qq_40286424的博客
05-06 1354
Springboot项目连接数据库报错：Caused by: java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES) 项目环境： 项目和数据库在Docker中运行，并配置有mysql容器的docker网络parkingmysql。 原因： 1.密码错误。 2.application.yml中数据库账号地址错误。 一般是 jdbc:mysql://localhost:3306/databas
Spingboot连Mysql出错：Cause:java.sql.SQLException: Access denied for user ‘root‘@‘hadoop100‘ (using pass
weixin_43820544的博客
07-29 789
mysql Acess denied的解决方案探索
Springboot： java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
MQZJ12345的专栏
08-22 214
Springboot： java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) yml配置： server: port: 9011 spring: application: name: goods datasource: driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://192.168
Cause: java.sql.SQLException: Access denied for user 'root'@'localhost'
08-15
SHOW GRANTS FOR 'root'@'localhost'; ``` 确保用户具有足够的权限来执行所需的操作。如果权限不足，你可以授予用户相应的权限，例如： ``` GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'; ``` 注意...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 8
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值