root'@'localhost 异常分析

 

这个异常出现的原因为配置文件中的数据库密码或者是dao层下的daoImpl实现方法时所使用的表名错误。

解决办法：修改配置文件中的数据库密码和方法中的数据库表名

 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    at cn.twitter.dao.MessageDaoImpl.<clinit>(MessageDaoImpl.java:33)

    at cn.twitter.service.MessageServiceImpl.<init>(MessageServiceImpl.java:11)

    at org.apache.jsp.message_jsp._jspService(message_jsp.java:96)

    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)

    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)

    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)

    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)

    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)

    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

    at java.lang.Thread.run(Thread.java:619)