How to fix " [08S01] Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. "

Question

I'm working on a PHP project using PhpStorm + DataGrip + MySQL + WAMP and since then was working normally with remote database with these configurations (see images):

but suddenly I'm getting this error:

[08S01] 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. java.net.ConnectException: Connection refused: connect

Could someone knows what can I do to solve this error?

I already tried to do what I found here (Solving a "communications link failure" with JDBC and MySQL) and that did not work yet.

I expect to connect again normally to my database.

Answer 1

Hi this error is because you are running a MySQL version 5 or 8.0 and later. And your server is configured to use the protocol of TLS 1.2. So, you need to enable TLS Protocols.

• Open Datagrip
• Go to Properties
• Data Sources > Advanced

In enabledTLSProtocol set the value:

TLSv1,TLSv1.1,TLSv1.2,TLSv1.3

Test connection. And should work!

Answer 2

edit the JDBC url and append this query parameter &enabledTLSProtocols=TLSv1.2