MySql with JAVA error. The last packet sent successfully to the server was 0 milliseconds ago

Question

I have read about this exception a lot, but I can't solve my.

Mysql server is working.

I can connect to it from NetBeans, but I can't connect to it from java code.

Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

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:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    at java.sql.DriverManager.getConnection(DriverManager.java:579)
    at java.sql.DriverManager.getConnection(DriverManager.java:243)
    at javaapplication3.JavaApplication3.main(JavaApplication3.java:32)
Caused by: java.net.SocketException: Permission denied: connect
    at java.net.DualStackPlainSocketImpl.connect0(Native Method)
    at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:69)
    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
    at java.net.Socket.connect(Socket.java:579)
    at java.net.Socket.connect(Socket.java:528)
    at java.net.Socket.<init>(Socket.java:425)
    at java.net.Socket.<init>(Socket.java:241)
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
    ... 15 more
Java Result: 1

I catch this exception with any ways to connect to Mysql from java code, but from MysqlWorkBench and from NetBeans is OK. I have no Firewall. I tried 127.0.0.1, result is the same.

Could you provide your code excample which trow this error? Also, please, specify your operating system, which JDBC file you are using and connection options. — Evgeniy Fitsner, Jan 28 '13 at 10:18
Windows 7. Standart MysqlDriver(mysql-connector) from NetBeans files. ( I tried to use downloaded from http://dev.mysql.com/downloads/connector/j/ but result is the same. Conection optons are http://piccy.info/view3/4045919/69d57c0c558cb4f6cdbe5de27b15621a/orig/) — user1113159, Jan 28 '13 at 10:30
Caused by: java.net.SocketException: Permission denied: connect It looks like you have no permission to connect, is is not a network problem, maybe username and pw — fredcrs, Jan 28 '13 at 10:41
This could happen when the server always verifies the certificates provided by users, you can disable SSL and also suppress the SSL errors by adding connection url as jdbc:mysql://localhost:3306/?autoReconnect=true&useSSL=false — Isuru, Jul 19 '19 at 07:24
Can you please try removing below property spring.datasource.driver-class-name=com.mysql.jdbc.Driver — SUMIT, Dec 15 '20 at 05:41

score 7 · Answer 1 · edited Aug 28 '19 at 22:28

7

Try to specify the port in

conn = DriverManager.getConnection("jdbc:mysql://localhost/mysql?"
                                        + "user=root&password=onelife");

I think you should have something like this:

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?"
                                            + "user=root&password=onelife");

Also, the port number in my example (3306) is the default port, but you may change it while installing MySQL.

I think that a better way to specify password and user is to separate them from the URL like this:

connection = DriverManager.getConnection(url, login, password);

edited Aug 28 '19 at 22:28

entpnerd

10,049
8
47
68

answered Jan 28 '13 at 10:24

Aliaksei Bulhak

6,078
8
45
75

Done. No results. Port is 3306. And port is working. I can successfuly connect from NeatBeans or MysqlWorckBench. – user1113159 Jan 28 '13 at 10:35
try this sql-connector http://code.google.com/p/find-ur-pal/downloads/detail?name=mysql-connector-java-5.1.18-bin.jar&can=2&q= – Aliaksei Bulhak Jan 28 '13 at 10:44
2

I solved it. I'm sorry to bother you all. Problem was in DrWeb firewall. I dont know why, but still I didnt close this programm firewall was working,even if i switched it off. – user1113159 Jan 28 '13 at 10:49

score 7 · Answer 2 · edited Sep 25 '14 at 19:27

7

Search the file my.cnf and comment the line

skip-networking

to

#skip-networking

Restart mysql

edited Sep 25 '14 at 19:27

jordanhill123

4,142
2
31
40

answered Sep 25 '14 at 18:43

Alan Cruz

137
1
3

In newer versions you have to comment out #bind-address = 127.0.0.1 – hy-soft Mar 25 '15 at 10:39
Thanks so much! You saved my day !! :) – tired and bored dev Jan 13 '17 at 07:51
Thank you this was working with me . – Abd Abughazaleh Jul 18 '20 at 17:18

score 6 · Answer 3 · answered May 25 '16 at 11:04

6

THis issue has been fixed with new mysql connectors, please use http://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.38

I used to get this error after updating the connector jar, issue resolved.

answered May 25 '16 at 11:04

lastextinct

61
1
2

score 5 · Answer 4 · edited Aug 28 '19 at 22:50

5

The problem is mostly due to a MySQL service that is not running, so make sure it is. If it isn't, run this CMD with administrator privilege in order to start it:

sc start [Your MySQL Service name]

edited Aug 28 '19 at 22:50

Sae1962

1,122
15
31

answered Dec 09 '13 at 18:49

Marwen Trabelsi

4,167
8
39
80

score 4 · Answer 5 · edited Aug 28 '19 at 22:42

4

Try the following suggestions:

Your machine may have a static IP; map this IP to the hosts file as localhost.
Try to log in from your computer or within the network via mysql command; if login is successful, it means that MySQL runs fine.

edited Aug 28 '19 at 22:42

Sae1962

1,122
15
31

answered Nov 21 '13 at 09:49

M S Parmar

955
8
22

score 2 · Answer 6 · edited Aug 28 '19 at 22:55

2

It seems that your Java code is using IPv6 instead of IPv4. Please try to use 127.0.0.1 instead of localhost. Ex.: Your connection string should be

jdbc:mysql://127.0.0.1:3306/expeditor?zeroDateTimeBehavior=convertToNull&user=root&password=onelife

P.S.: Please update the URL connection string.

edited Aug 28 '19 at 22:55

Sae1962

1,122
15
31

answered Jan 28 '13 at 10:40

Evgeniy Fitsner

946
9
14

read post accurately. he wrote that 'I tried 127.0.0.1, result is the same' – Aliaksei Bulhak Jan 28 '13 at 10:41
I did it. Result is the same. :-( – user1113159 Jan 28 '13 at 10:42
I solved it. I'm sorry to bother you all. Problem was in DrWeb firewall. I dont know why, but still I didnt close this programm firewall was working,even if i switched it off. – user1113159 Jan 28 '13 at 10:49

score 2 · Answer 7 · edited May 30 '16 at 00:43

2

There are two things

Disable firewall if any or add exception or check if u have correct driver file. Disable any antivirus if any
and also make sure your driver type is mysql.jdbc.driver.

edited May 30 '16 at 00:43

Andri

1,503
13
20

answered Dec 08 '14 at 07:22

Develop4Life

7,581
8
58
76

Disabling windows firewall worked for me. – Developine Apr 19 '17 at 10:55

MySql with JAVA error. The last packet sent successfully to the server was 0 milliseconds ago

7 Answers7

Linked