Connecting to MySQL 8.0 with SSL Mode Disabled (ERROR 2026 (HY000): SSL Connection Error: Error Handling)
2021-01-01 21:28 (4 years ago)
ytyng
When I tried to connect from MySQL Client 8.0 to MySQL 5.6,
in DataGrip, I encountered the following message:
[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.io.EOFException: SSL peer shut down incorrectly.
On the command line, I got the following error:
% mysql --host=xxxxx --user=xxxxx --password
Enter password:
ERROR 2026 (HY000): SSL connection error: error:1408F10B:SSL routines:ssl3_get_record:wrong version number
This error occurs because the server is originally serving with SSL disabled, but the client is attempting to connect with SSL enabled, resulting in a failure.
It is possible that this issue is due to a mismatch between the version of SSL on the client side and the encryption method supported by SSL on the server side.
By the way, the OpenSSL version on the client-side Mac is:
% openssl version
LibreSSL 2.8.3
If you are okay with not using SSL and transmitting in plaintext,
for the mysql command, you can add --ssl-mode=DISABLED.
% mysql --host=xxxxx --user=xxxxx --password --ssl-mode=DISABLED
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1693381
Server version: 5.6.34-log MySQL Community Server (GPL)
In the case of DataGrip, there is a setting item called useSSL in the Advanced tab of the connection settings. Change this to FALSE.
We look forward to discussing your development needs.