Error updating database. Cause: java.sql.SQLException: Access denied for user '${username}'@'localhost' (using password: YES)

时间：2023-03-09 00:02:32
Error updating database. Cause: java.sql.SQLException: Access denied for user '${username}'@'localhost' (using password: YES)

导入别人的项目，出现一个错误，经过排查，是db.properties配置文件中的用户名与Mybatis-conf.xml配置文件中调用的用户名不一致所导致的

（db.properties中用的是name,而调用时用的确实username ，即${username}），只要把配置文件中的name改为username即可。

截图如下：

Error updating database. Cause: java.sql.SQLException: Access denied for user '${username}'@'localhost' (using password: YES)

Error updating database. Cause: java.sql.SQLException: Access denied for user '${username}'@'localhost' (using password: YES)

org.apache.ibatis.exceptions.PersistenceException:

### Error updating database.  Cause: java.sql.SQLException: Access denied for user '${username}'@'localhost' (using password: YES)

### Cause: java.sql.SQLException: Access denied for user '${username}'@'localhost' (using password: YES)

    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:)

    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:)

    at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:)

    at dbBookTest.StudentCERUDTest.add(StudentCERUDTest.java:)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:)

    at java.lang.reflect.Method.invoke(Method.java:)

    at org.junit.runners.model.FrameworkMethod$.runReflectiveCall(FrameworkMethod.java:)

    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:)

    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:)

    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:)

    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:)

    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:)

    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:)

    at org.junit.runners.ParentRunner$.run(ParentRunner.java:)

    at org.junit.runners.ParentRunner$.schedule(ParentRunner.java:)

    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:)

    at org.junit.runners.ParentRunner.access$(ParentRunner.java:)

    at org.junit.runners.ParentRunner$.evaluate(ParentRunner.java:)

    at org.junit.runners.ParentRunner.run(ParentRunner.java:)

    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:)

    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:)

Caused by: java.sql.SQLException: Access denied for user '${username}'@'localhost' (using password: YES)

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:)

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:)

    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:)

    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:)

    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:)

    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:)

    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:)

    at com.mysql.jdbc.Util.handleNewInstance(Util.java:)

    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:)

    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:)

    at java.sql.DriverManager.getConnection(DriverManager.java:)

    at java.sql.DriverManager.getConnection(DriverManager.java:)

    at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:)

    at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:)

    at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:)

    at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:)

    at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:)

    at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:)

    at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:)

    at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:)

    at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:)

    at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:)

    at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:)

    at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:)

    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:)

    ...  more

相关文章