报Access denied for user '13454'@'localhost' (using password: YES)错误

最新推荐文章于 2025-05-13 22:14:58 发布

原创最新推荐文章于 2025-05-13 22:14:58 发布 · 218 阅读

0 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

3 篇文章

订阅专栏

本文详细记录了在使用MyBatis框架时遇到的数据库连接错误，具体表现为权限拒绝，通过调整配置文件中的数据库连接参数成功解决了问题。

报如下错误

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 '13454'@'localhost' (using password: YES)
### The error may exist in com/dao/bookmapper.xml
### The error may involve com.dao.Booksmapper.querybooks
### 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 '13454'@'localhost' (using password: YES)

配置文件代码如下
db.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf8
username=root
password=123456

连接数据库配置文件

<context:property-placeholder location="classpath:db.properties"/>
   <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${driver}"/>
        <property name="url"      value="${url}" />
        <property name="username" value="${username}" />
        <property name="password" value="${password}" />
    </bean>

看起来明明就没有错.最后在db.properties中加上前缀就好了

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf8
jdbc.username=root
jdbc.password=123456