spring和mybatis整合时Access denied for user ‘***’@‘localhost’ (using password: YES)错误的解决方案
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 '王茂茂'@'localhost' (using password: YES)
### The error may exist in class path resource [wmm.smm2.mapper/StudentMapper.xml]
### The error may involve wmm.ssm2.mapper.StudentMapper.findAllStu
### 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 '王茂茂'@'localhost' (using password: YES)
在保证能成功连接数据库后,发现一直报Access denied for user ‘***’@‘localhost’ (using password: YES)错误
解决方案:
在数据库配置文件中将key = value 改为 xx.key = value
更改后
在对应的数据源中也要记得更改哦