Cause: java.sql.SQLException: Access denied for user ‘‘@‘localhost‘ (using password: YES)

最新推荐文章于 2023-09-13 19:49:17 发布
行躬
最新推荐文章于 2023-09-13 19:49:17 发布
阅读量485
点赞数
分类专栏： mybatis 文章标签： java mybatis
本文链接：https://blog.csdn.net/weixin_45846799/article/details/120866206
版权
mybatis 专栏收录该内容
5 篇文章 0 订阅
订阅专栏
D:\Java\jdk-1.8.0\bin\java.exe "-javaagent:D:\Java\IntelliJ IDEA 2019.3.5\lib\idea_rt.jar=16370:D:\Java\IntelliJ IDEA 2019.3.5\bin" -Dfile.encoding=UTF-8 -classpath D:\Java\jdk-1.8.0\jre\lib\charsets.jar;D:\Java\jdk-1.8.0\jre\lib\deploy.jar;D:\Java\jdk-1.8.0\jre\lib\ext\access-bridge-64.jar;D:\Java\jdk-1.8.0\jre\lib\ext\cldrdata.jar;D:\Java\jdk-1.8.0\jre\lib\ext\dnsns.jar;D:\Java\jdk-1.8.0\jre\lib\ext\jaccess.jar;D:\Java\jdk-1.8.0\jre\lib\ext\jfxrt.jar;D:\Java\jdk-1.8.0\jre\lib\ext\localedata.jar;D:\Java\jdk-1.8.0\jre\lib\ext\nashorn.jar;D:\Java\jdk-1.8.0\jre\lib\ext\sunec.jar;D:\Java\jdk-1.8.0\jre\lib\ext\sunjce_provider.jar;D:\Java\jdk-1.8.0\jre\lib\ext\sunmscapi.jar;D:\Java\jdk-1.8.0\jre\lib\ext\sunpkcs11.jar;D:\Java\jdk-1.8.0\jre\lib\ext\zipfs.jar;D:\Java\jdk-1.8.0\jre\lib\javaws.jar;D:\Java\jdk-1.8.0\jre\lib\jce.jar;D:\Java\jdk-1.8.0\jre\lib\jfr.jar;D:\Java\jdk-1.8.0\jre\lib\jfxswt.jar;D:\Java\jdk-1.8.0\jre\lib\jsse.jar;D:\Java\jdk-1.8.0\jre\lib\management-agent.jar;D:\Java\jdk-1.8.0\jre\lib\plugin.jar;D:\Java\jdk-1.8.0\jre\lib\resources.jar;D:\Java\jdk-1.8.0\jre\lib\rt.jar;D:\Java\maven\com.xurong1\OneDay\target\test-classes;D:\Java\maven\com.xurong1\OneDay\target\classes;D:\Java\maven\maven_repository\org\mybatis\mybatis\3.5.7\mybatis-3.5.7.jar;D:\Java\maven\maven_repository\mysql\mysql-connector-java\8.0.25\mysql-connector-java-8.0.25.jar;D:\Java\maven\maven_repository\com\google\protobuf\protobuf-java\3.11.4\protobuf-java-3.11.4.jar;D:\Java\maven\maven_repository\com\att\inno\log4j\1.2.13\log4j-1.2.13.jar;D:\Java\maven\maven_repository\com\att\inno\env\1.2.13\env-1.2.13.jar;D:\Java\maven\maven_repository\net\java\dev\jna\jna-platform\4.0.0\jna-platform-4.0.0.jar;D:\Java\maven\maven_repository\net\java\dev\jna\jna\4.0.0\jna-4.0.0.jar;D:\Java\maven\maven_repository\org\apache\isis\viewer\junit\0.2.0-incubating\junit-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\progmodels\wrapper-metamodel\0.2.0-incubating\wrapper-metamodel-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\progmodels\wrapper-applib\0.2.0-incubating\wrapper-applib-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\applib\0.2.0-incubating\applib-0.2.0-incubating.jar;D:\Java\maven\maven_repository\joda-time\joda-time\1.6.2\joda-time-1.6.2.jar;D:\Java\maven\maven_repository\org\apache\isis\runtimes\dflt\bytecode\dflt\0.2.0-incubating\dflt-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\runtimes\dflt\objectstores\dflt\0.2.0-incubating\dflt-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\runtimes\dflt\runtime\0.2.0-incubating\runtime-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\core\runtime\0.2.0-incubating\runtime-0.2.0-incubating.jar;D:\Java\maven\maven_repository\commons-cli\commons-cli\1.2\commons-cli-1.2.jar;D:\Java\maven\maven_repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;D:\Java\maven\maven_repository\org\apache\isis\runtimes\dflt\bytecode\identity\0.2.0-incubating\identity-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\runtimes\dflt\profilestores\dflt\0.2.0-incubating\dflt-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\security\dflt\0.2.0-incubating\dflt-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\progmodels\dflt\0.2.0-incubating\dflt-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\core\progmodel\0.2.0-incubating\progmodel-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\core\metamodel\0.2.0-incubating\metamodel-0.2.0-incubating.jar;D:\Java\maven\maven_repository\org\apache\isis\core\commons\0.2.0-incubating\commons-0.2.0-incubating.jar;D:\Java\maven\maven_repository\commons-collections\commons-collections\3.2.1\commons-collections-3.2.1.jar;D:\Java\maven\maven_repository\commons-codec\commons-codec\1.6\commons-codec-1.6.jar;D:\Java\maven\maven_repository\com\google\inject\guice\3.0\guice-3.0.jar;D:\Java\maven\maven_repository\javax\inject\javax.inject\1\javax.inject-1.jar;D:\Java\maven\maven_repository\aopalliance\aopalliance\1.0\aopalliance-1.0.jar;D:\Java\maven\maven_repository\asm\asm\3.1\asm-3.1.jar;D:\Java\maven\maven_repository\org\objenesis\objenesis\1.2\objenesis-1.2.jar;D:\Java\maven\maven_repository\cglib\cglib-nodep\2.1_3\cglib-nodep-2.1_3.jar;D:\Java\maven\maven_repository\org\jmock\jmock\2.5.1\jmock-2.5.1.jar;D:\Java\maven\maven_repository\org\hamcrest\hamcrest-core\1.1\hamcrest-core-1.1.jar;D:\Java\maven\maven_repository\org\jmock\jmock-junit4\2.5.1\jmock-junit4-2.5.1.jar;D:\Java\maven\maven_repository\org\jmock\jmock-legacy\2.5.1\jmock-legacy-2.5.1.jar;D:\Java\maven\maven_repository\junit\junit\4.10\junit-4.10.jar;D:\Java\maven\maven_repository\log4j\log4j\1.2.16\log4j-1.2.16.jar;D:\Java\maven\maven_repository\com\google\guava\guava\11.0\guava-11.0.jar;D:\Java\maven\maven_repository\com\google\code\findbugs\jsr305\1.3.9\jsr305-1.3.9.jar;D:\Java\maven\maven_repository\org\hamcrest\hamcrest-library\1.1\hamcrest-library-1.1.jar com.xurong.test.MybatiesTest
2021-10-20 14:49:50,516 0      [           main] DEBUG ache.ibatis.logging.LogFactory  - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
2021-10-20 14:49:50,550 34     [           main] DEBUG source.pooled.PooledDataSource  - PooledDataSource forcefully closed/removed all connections.
2021-10-20 14:49:50,550 34     [           main] DEBUG source.pooled.PooledDataSource  - PooledDataSource forcefully closed/removed all connections.
2021-10-20 14:49:50,550 34     [           main] DEBUG source.pooled.PooledDataSource  - PooledDataSource forcefully closed/removed all connections.
2021-10-20 14:49:50,550 34     [           main] DEBUG source.pooled.PooledDataSource  - PooledDataSource forcefully closed/removed all connections.
2021-10-20 14:49:50,665 149    [           main] DEBUG ansaction.jdbc.JdbcTransaction  - Opening JDBC Connection
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES)
### The error may exist in com/xu/dao/IUserDao.xml
### The error may involve com.xu.dao.IUserDao.findAll
### The error occurred while executing a query
### Cause: java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES)
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
	at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
	at com.sun.proxy.$Proxy4.findAll(Unknown Source)
	at com.xurong.test.MybatiesTest.main(MybatiesTest.java:41)
Caused by: java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:208)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:224)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:219)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:95)
	at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:432)
	at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:89)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:139)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:61)
	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
	... 8 more

Process finished with exit code 1