SpringMVC+myBatis启动报错:Access denied for user 'stati'@'localhost' (using password: YES)
来源:互联网 发布:免费刷超级会员软件 编辑:程序博客网 时间:2024/05/01 16:49
这个错误有点莫名其妙;在另一个工程中用的同样的配置不报错;但就这个新工程就有这一问题;
我这里“数据库链接-账户-密码”都没有问题的;用Navicat for Mysql工具是能链接成功的,所以排除了这几个错误原因;
虽然解决了这个问题;但问题原因不知道;
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'stati'@'localhost' (using password: YES))### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'stati'@'localhost' (using password: YES))
报错前的配置是这样写的:
<bean id="dataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource" p:driverClassName="${driver}" p:url="${url}" p:username="${username}" p:password="${password}" p:initialSize="${initialSize}" p:maxActive="${maxActive}" p:maxIdle="${maxIdle}" p:minIdle="${minIdle}" p:maxWait="${maxWait}"/>
之后改成如下就正常了:
<bean id="dataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource" p:driverClassName="${db.driver}" p:url="${db.url}" p:username="${db.username}" p:password="${db.password}" p:initialSize="${db.initialSize}" p:maxActive="${db.maxActive}" p:maxIdle="${db.maxIdle}" p:minIdle="${db.minIdle}" p:maxWait="${db.maxWait}"/>
就是在前面配置名前加了一个"db."将这一错误解决了;
1 0
- SpringMVC+myBatis启动报错:Access denied for user 'stati'@'localhost' (using password: YES)
- SpringMVC+myBatis启动报错:Access denied for user '##.##'@'localhost' (using password: YES)
- MySQL for mac 连接报错:Access denied for user 'root'@'localhost' (using password: YES)
- 解决:maven+SSM+durid+mysql启动报错: Access denied for user 'root '@'localhost' (using password: YES)
- MySQL改密码报错:ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
- mysql报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql报错 Access denied for user 'root'@'localhost' (using password: YES)
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- Grant的时候报错的解决:Access denied for user 'root'@'localhost' (using password: YES)
- Grant的时候报错的解决:Access denied for user 'root'@'localhost' (using password: YES)
- mysql 链接报错Access denied for user 'root'@'localhost' (using password :Yes
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- Spring4+Struts2+Hibernate5报错:Access denied for user 'root'@'localhost' (using password: YES)
- MYsql:1045 access denied for user 'root'@'localhost' using password yes 报错问题
- myeclipse 报错Access denied for user 'root'@'localhost' (using password: YES)
- java连接mysql5.7报错Access denied for user 'root'@'localhost' (using password: YES)解决
- 连接mysql报错Access denied for user 'root'@'localhost' (using password: YES)解决办法
- c3p0加载properties配置文件 报错 Access denied for user 'Administrator'@'localhost' (using password: YES)
- HTML mata标签详解
- (已解)不初始化APP,进行运行
- MySQL5.7安装过程和一些坑
- ZOJ-3696 Alien's Organ(泊松分布)
- 代码整洁之道精华——第二章 有意义的命名
- SpringMVC+myBatis启动报错:Access denied for user 'stati'@'localhost' (using password: YES)
- code review的做法以及问题
- 汪海Python爬虫(一)抓取网页的含义和URL基本构成
- Spring <context:annotation-config/> 解说
- 思科模拟器:通过ip route命令将三台路由器相接的两台电脑连通
- var 作用域||变量
- 《JavaScript高级程序设计 第三版》学习笔记 (十一)事件详解
- Servlet学习笔记一
- linux中的硬件抽象层