【报错】SQLException: Access denied for user 'root'@'localhost'

客官°小女子只卖身不卖艺 2022-09-22 04:59 181阅读 0赞

【报错】

log4j:WARN No appenders could be found for logger (org.hibernate.type.BasicTypeRegistry).

log4j:WARN Please initialize the log4j system properly.  
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html\#noconfig for more info.  
Tue Jun 28 14:11:17 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.  
Tue Jun 28 14:11:18 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.  
org.hibernate.exception.GenericJDBCException: Cannot open connection  
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)  
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)  
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)  
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)  
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)  
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)  
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160)  
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81)  
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473)  
at com.tgbnode.hibernate.Client.main(Client.java:24)  
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)  
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)  
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)  
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)  
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:875)  
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1712)  
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1228)  
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)  
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)  
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)  
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)  
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)  
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)  
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)  
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)  
at java.lang.reflect.Constructor.newInstance(Unknown Source)  
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)  
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)  
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)  
at java.sql.DriverManager.getConnection(Unknown Source)  
at java.sql.DriverManager.getConnection(Unknown Source)  
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)  
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)  
... 5 more  
Exception in thread "main" org.hibernate.TransactionException: Transaction not successfully started  
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:179)  
at com.tgbnode.hibernate.Client.main(Client.java:39)

【解决】

账号和密码错误，修改完善即可 ！