Spring+MyBatis时Access denied for user '高欢欢'@'localhost' (using password: YES)的异常解决方案
2024-08-29 01:59:00
今天在做spring+mybatis整合的时候系统只要一运行就会报下面的错误,搞了几个小时硬是没有找的原因
警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7de1c0d3 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: Access denied for user '高欢欢'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1709)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor7.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
将C3P0换成了Druid也是不行,正准备放弃的时候,在网上看到一篇文章说是数据库配置文件有问题,马上进行了一番操作
竟然是上图中的
username
出现问题,随即将其修改为user即可,
但是又出现了下面的问题
就是你的spring版本要和Mybatis-spring和spring的版本要相对应
具体参考下面即可
最新文章
- 网易云音乐PC端刷曲快捷键
- Kylin Java RESTful API
- 用C#制作推箱子小游戏
- Yocto开发笔记之《Tip-应用程序无法在目标机运行》(QQ交流群:519230208)
- 阿里云(ECS)Centos服务器LNMP环境搭建
- 《UML大战需求分析》阅读笔记01
- 课时9—popup
- 新手入门之GDB调试
- Hibernate案例-------基于xml配置,使用Hibernate实现对员工表的增、删、改、查功能
- Laravel5.1 启动详解
- SQL Server 索引和表体系结构(一)
- Jenkins插件及 测试源码
- Regex 例
- 绿盟RSAS配置小记
- Android5.0特性阴影效果和裁剪
- Linux 安装多个版本JDK并设置默认版本
- Java 向MySql 插入日期和时间正确的姿势
- 什么是HTML?
- bootstrap是什么
- field_automation源码分析