[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. javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate).

Mysql > update datagrip;

Rebooting didn’t fix the problem!

Changing the drive didn’t solve the problem!

The TLS version of the JDK’s security Settings is responsible. OracleJDK8u201, AdoptOpenJDK8, AdoptOpenJDK11, Datagrip JBR1, idea JBR11, pycharm JBR11 Which is related to a JDK. TLS. DisabledAlgorithms

The configuration in OracleJDK8u201 is:

jdk.tls.disabledAlgorithms=SSLv3, RC4, DES, MD5withRSA, DH keySize < 1024, \
    EC keySize < 224, 3DES_EDE_CBC, anon, NULL
Copy the code

Pycharm JBR11

jdk.tls.disabledAlgorithms=SSLv3, RC4, DES, MD5withRSA, DH keySize < 1024, \
    EC keySize < 224, 3DES_EDE_CBC, anon, NULL, \
    include jdk.disabled.namedCurves
Copy the code

In all the other versions

JDK. TLS. DisabledAlgorithms = SSLv3, TLSv1 TLSv1.1, DES, RC4, MD5withRSA, \ DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL, \ include jdk.disabled.namedCurvesCopy the code

After comparison, TLSv1 and TLSv1.1 algorithms are banned. In this solution, TLSv1 and TLSv1.1 in datagrip JBR11 configurations are deleted

You can connect to mysql properly after the restart