jsp 连接 MYSQL 数据库被拒绝 ,是什么原因?

jspxp

系统是 rd9.0 ,mysql使用的是系统自带的 ,安装了tomcat5.0 ,jdbc驱动也装了,好像是数据库验证出了问题,改怎么办?

[root@vip root]# mysql -h 127.0.1 -u root -p
Enter password:
ERROR 1130: Host 'vip' is not allowed to connect to this MySQL server

[root@vip root]# mysql  -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 3.23.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>






HTTP Status 500 -

type 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: "Host '10.106.1.243' 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.test1_jsp._jspService(test1_jsp.java:109)
        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

patirot

MySQL 不允许这个主机连接，估计是只设置了localhost允许。
在MySQL里添加允许这个主机接入就可以了。
你的MySQL也不允许本地机接入？？？
这个我就没明白了，MySQL里的mysql数据库错了吗？

jspxp

我将 登录信息里 主机:localhost 改为 任意主机  就可以了,为什么会这样呢?