After MySQL upgrade, clients receive ERROR 2026 (HY000): SSL connection error
book
Article ID: 373584
calendar_today
Updated On:
Products
VMware Tanzu Application ServiceVMware Tanzu MySQL
Issue/Introduction
Customers who upgrade their MySQL tile may report clients unable to connect to the new MySQL servers.
One such error is "ERROR 2026 (HY000): SSL connection error: unknown error number"
Resolution
MySQL error "ERROR 2026 (HY000): SSL connection error: unknown error number" can have multiple causes:
Old client: The client you're using might not support modern TLS versions.
TLS v1.1: TLS v1.1 is not supported by modern versions of MySQL and MariaDB.
SSL not supported: The server or engine version you're using might not support SSL.
yaSSL: If the MySQL connector was compiled with yaSSL, it might only support TLSv1 and TLSv1.1, which are no longer supported in MySQL 8.0.28 and later
Here are some things you can try to fix the error:
Upgrade your client
Configure MySQL to only support modern TLS versions and ciphers
Migrate to an engine that supports SSL connections
Build libmysql with OpenSSL to enable TLSv1.2 support