Spring整合Mybatis报错Access denied for user ‘1‘@‘localhost‘ (using password: YES)

尚墨1111

于 2021-03-13 15:39:58 发布

阅读量331

点赞数

CC 4.0 BY-SA版权

分类专栏：漫漫踩坑路

本文链接：https://blog.csdn.net/qq_42647903/article/details/114748862

漫漫踩坑路专栏收录该内容

50 篇文章

订阅专栏

本文针对在IDEA中遇到的数据库连接失败问题进行了深入分析。主要表现为应用无法连接数据库，但IDEA工具自身检测正常。通过排查发现是由于配置文件中的JDBC驱动路径设置错误所导致。文中详细记录了解决过程及正确配置方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

问题：报错连接不上数据库，但是在IDEA上检测数据库连接又是正常的

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user '1'@'localhost' (using password: YES)
### The error may exist in file [D:\MyApp\JavaWeb\Spring-study\spring-04-mybatis\target\classes\com\mytest\mapper\userMapper.xml]
### The error may involve com.mytest.mapper.UserMapper.getList
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user '1'@'localhost' (using password: YES)

在这里插入图片描述