"com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure" to remote database

Question

I tried to connect to my remote MySQL database, but I failed and got this error.

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The confusion is that It was effective when I used MySQL-Front tool to connect the remote database, and I can ping to the IP address successfully. but when I used my code, it wound show the error after about ten seconds.

Also when I used the wrong username or password in my code, it wound show the wrong verification immediately. Did that prove it is no problem to set up conection?

Here is my code(It can work on my localhost database):

public static void main(String[] args) {
        String url = "jdbc:mysql://(IP address):3306/";
        String dbName = "talk";
        String driver = "com.mysql.jdbc.Driver";
        String userName = "talkroot";
        String password = "123456";
        try {
            Class.forName(driver).newInstance();
            Connection conn = DriverManager.getConnection(url + dbName,
                    userName, password);
            System.out.println("connect");
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        System.out.println("end");
    }

Here is the error:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    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:2120)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at com.test.TestMySQL.main(TestMySQL.java:16)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 21298 ms ago.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
    at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1802)
    at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3444)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2062)
    ... 12 more
Caused by: java.net.SocketException: Software caused connection abort: recv failed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(Unknown Source)
    at java.net.SocketInputStream.read(Unknown Source)
    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2452)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906)
    ... 20 more

Anyone can help me please?

is your mysql server running ? search about **Software caused connection abort: recv failed** — Aman Gupta, Feb 23 '14 at 03:44
It is running.I can connect it and operate it using MySQL-Front. — chenupt, Feb 23 '14 at 03:48
Does MySQL-Front time out if left connected for a long time? — chrylis -cautiouslyoptimistic-, Feb 23 '14 at 03:48
I never try this. If it wound happen, what is problem with it? — chenupt, Feb 23 '14 at 03:59
kindly refer the below url: **http://stackoverflow.com/questions/2983248/com-mysql-jdbc-exceptions-jdbc4-communicationsexception-communications-link-fai** — Lakshmikandan, May 21 '14 at 12:42

score 3 · Answer 1 · answered Feb 26 '15 at 09:43

This com.mysql.jdbc.exceptions.jdbc4.CommunicationsException exception occurs if your database connection is idle for long time. This idle connection returns true on connection.isClosed(); but if we try to execute statement then it will fire this exception so I will suggest to go with database pooling.

score 2 · Answer 2 · answered Feb 26 '15 at 13:30

Usually this error occurs when you don't use right port number. May be the machine which working on this database (client'db) has different port number. (Ex: 3307) .
Go task manager==> Services ==> services and check is there other version of mysql. if they use 3306 change your port to 3307.

score 1 · Answer 3 · answered Oct 09 '14 at 02:57

1

you can try to replace the mysql-connector-java-version.jar jar file. Some people update the jar file from 5.1.10 to 5.1.14, then it works. Wish you are luck..

answered Oct 09 '14 at 02:57

Jingyuan Liu

11
2

score 1 · Answer 4 · answered Aug 24 '15 at 21:27

1

update your drive version to:

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.18</version>

answered Aug 24 '15 at 21:27

Aleja Chica

61
1
1
7

score 1 · Answer 5 · answered Aug 27 '15 at 07:10

Double Check the following things:

Verify whether the IP address/Port Number is correct or not
Ping to the server using ping "IP address" it may tells is the server in startup mode/shutdown mode
If you are getting connection objects from connection pool, verify once connections availability.

Hope this information helps...

score 1 · Answer 6 · answered Sep 11 '15 at 18:27

1

I solved it by removing the port number from the connection URL.

So instead of using connection string as:

jdbc:mysql://12x.xxx.xxx.xxx:1527/yourdbname

use

jdbc:mysql://12x.xxx.xxx.xxx/yourdbname

answered Sep 11 '15 at 18:27

Pranjal Sahu

1,469
3
18
27

score 1 · Answer 7 · edited Jun 20 '20 at 09:12

Also when I used the wrong username or password in my code, it wound show the wrong verification immediately. Did that prove it is no problem to set up conection?

this is probably done locally. so it doesn't relate to why your code isn't working.

There seems to be many ways to go about this, so you can try multiple things; people have solved this link failure in different ways as per their own situations:

Here are some the solutions:

changing "bind-address" attribute

Uncomment "bind-address" attribute or change it to one of the following IPs:

bind-address="127.0.0.1"

or

bind-address="0.0.0.0"

commenting out "skip-networking"

If there is a "skip-networking" line in your MySQL config file, make it comment by adding "#" sign at the beginning of that line.

change "wait_timeout" and "interactive_timeout"

Add these lines to the MySQL config file:

[wait_timeout][1] = number

interactive_timeout = number

connect_timeout = number

check Operating System proxy settings

Make sure the Fire wall, or Anti virus soft wares don't block MySQL service.

change connection string

Check your query string. your connection string should be some thing like this:

dbName = "my_database";
dbUserName = "root";
dbPassword = "";
String connectionString = "jdbc:mysql://localhost/" + dbName + "?user=" + dbUserName + "&password=" + dbPassword + "&useUnicode=true&characterEncoding=UTF-8";

Make sure you don't have spaces in your string. All the connection string should be continues without any space characters.

Try to replace "localhost" with your port, like 127.0.0.1. Also try to add port number to your connection string, like:

String connectionString = "jdbc:mysql://localhost:3306/my_database?user=root&password=Pass&useUnicode=true&characterEncoding=UTF-8";

Usually default port for MySQL is 3306.

Don't forget to change username and password to the username and password of your MySQL server.

update your JDK driver library file
test different JDK and JREs (like JDK 6 and 7)
don't change max_allowed_packet

"[max_allowed_packet][4]" is a variable in MySQL config file that indicates the maximum packet size, not the maximum number of packets. So it will not help to solve this error.

change tomcat security

change TOMCAT6_SECURITY=yes to TOMCAT6_SECURITY=no

use validationQuery property

use validationQuery="select now()" to make sure each query has responses

AutoReconnect

Add this code to your connection string:

&autoReconnect=true&failOverReadOnly=false&maxReconnects=10

score 1 · Answer 8 · answered Nov 14 '15 at 19:04

1

Your MySQL server isn't running. Check the same in the services page of the task manager if you are running Windows.

answered Nov 14 '15 at 19:04

Mahadev

31
3

score 0 · Answer 9 · edited Aug 10 '17 at 10:55

0

If you are working with Amazon Ubuntu instance then you have to follow this steps:

Check the amazon instance
Check the security group of instance
Assign the mysql/aura service and add your machine ip here or service provider ip.

edited Aug 10 '17 at 10:55

Regolith

2,944
9
33
50

answered Aug 10 '17 at 10:25

shivamindalkar

1
2

score 0 · Answer 10 · answered Sep 11 '17 at 08:24

Please update your mysql configuration file in /etc/mysql/my.cnf file

By default, MySQL only allows connections from the localhost address. The configuration file is usually found in /etc/mysql/my.cnf

You will want to comment out the bind-address line by making it look like this:

#bind-address     = 127.0.0.1

Next, you will need to restart the database server:

sudo /etc/init.d/mysql restart

score 0 · Answer 11 · answered Mar 28 '19 at 05:43

I had faced this issue and struggled a lot like a lot. I did everything single thing said in all the portals and not worked for me. The only thing which worked to me was updating my jar file to the current new version . Earlier I was using 5.1.38 and now updated to 8.0.15 and just that my program worked super fine.

"com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure" to remote database

11 Answers11

Here are some the solutions:

Linked