当前位置: 代码迷 >> Java Web开发 >> MySQL联接不上
  详细解决方案

MySQL联接不上

热度:182   发布时间:2016-04-17 00:52:36.0
MySQL连接不上
电脑还原后重装MySQL,重装时步骤可能和以前不太一样(端口变成了8089),数据库安装算是成功吧,MySQL数据库显示正常。但用以前的程序改端口连接不上了,不知什么原因,希望各路高手为我解题。
Java code
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.    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.SQLError.createCommunicationsException(SQLError.java:1074)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2209)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)    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:352)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)    at java.sql.DriverManager.getConnection(DriverManager.java:582)    at java.sql.DriverManager.getConnection(DriverManager.java:154)    at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)    at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)    at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)    at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)    at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)    at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)    ... 26 moreCaused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure


------解决方案--------------------
都能改。
------解决方案--------------------
你看你报错的第一句话,意思不就是包都发过去了 但是那边却没有收到 所以我觉得还是端口问题
不知道你那个分8089是不是被其他程序占用了,或者我觉得就算重装后你为什么要改成8089呢?我记得tomcat的有一个配置文件里好像出现过8089 这个端口号 可能就和它有关系
难道你用3306 就不行了吗?
------解决方案--------------------
看看是不是防火墙阻止了访问 第二看看你设置了没有mysql的远程连接
------解决方案--------------------
网络问题,收不到服务端数据
代码迷推荐解决方案:The driver has not received any packets from the server.,http://www.daimami.com/search?q=345243
  相关解决方案