关于jdbc,我实在是不知道f怎么回事,大虾们帮我看看

tboqi

Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: null,  message from server: "#HY000Host 'localhost.localdomain' is not allowed to connect to this MySQL server"
        org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
        org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
        org.apache.jsp.mysqltest1_jsp._jspService(mysqltest1_jsp.java:57)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: null,  message from server: "#HY000Host 'localhost.localdomain' is not allowed to connect to this MySQL server"
        com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:970)
        com.mysql.jdbc.Connection.createNewIO(Connection.java:1768)
        com.mysql.jdbc.Connection.<init>(Connection.java:430)
        com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
        java.sql.DriverManager.getConnection(DriverManager.java:512)
        java.sql.DriverManager.getConnection(DriverManager.java:193)
        org.apache.jsp.mysqltest1_jsp._jspService(mysqltest1_jsp.java:48)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

linux+mysql+jsp,这个是哪里错了
先谢谢了

xlwcat

似乎是权限的问题。。不让连接到mysql server。。

tboqi

这个问题怎么解决，我的mysql是默认安装的

eTony

检查你的 mysql 中 mysql.user 表的用户权限

menglianjing

先用root连接试试

tboqi

我一直事在用root用户

menglianjing

UPDATE db SET host=('%')  WHERE user='root'