*****一个MYSQL数据库连接的问题,高手指正!急急急****
我的JSP程序是这样的:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost:3306/test";
String user ="root";
String password ="";
Connection conn= DriverManager.getConnection(url,user,password);
%>
运行后出现如下错误提示:
javax.servlet.ServletException: Invalid authorization specification: Access denied for user 'root'@'localhost' (using password: NO)
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.test_jsp._jspService(test_jsp.java:61)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
我以前也用过TOMCAT和mysql,但连接上从未出现过这种问题!
我用的环境是tomcat5.0+mysql5.0.1alpha