偶在win和linux都遇到这样地错误提示:"Is there a server running on localhost:3306?"

[pgcat]

mysql是运行着的~
代码也没有问题~ 因为喊简单
<%@ page contentType="text/html;charset=8859_1"%>

<%
//声明
java.sql.Connection sqlConn;//数据库连接对象
java.sql.Statement sqlStmt;//语句对象
java.sql.ResultSet sqlRst;//结果集对象

//登记JDBC驱动程序
Class.forName("org.gjt.mm.mysql.Driver").newInstance();

//连接数据库
sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/test","pgcat","123456");
。。。 。。。
%>

[advanced]

你的数据库服务没启动，或是启动了绑定的端口不是3306

[advanced]

端口设置正确么？

[pgcat]

mysql启动了的~ 端口也是3306。
下面是一些错误提示
-----------------------------------
org.apache.jasper.JasperException: Communication failure during handshake. Is there a server running on localhost:3306?
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:536)

[sgdb]

sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/test&user=pgcat&password=123456");

[pgcat]

Cannot connect to MySQL server on 127.0.0.1:3306. Is there a MySQL server running on the machine/port you are trying to connect to?
老是报这样的错误，可是mysql确实正在运行~ 对这样的数据库连接mysql运行需要加什么参数吗？

[dongdongshu]

他的提示是无法获取端口，你改一下MYSQL的端口设置就OK了`~
GOOD LUCK！

[pgcat]

怎么修改一下MYSQL的端口设置：）

[pgcat]

up 1下

[sgdb]

C:\WINNT\my.ini里修改！
默认3306