After MySQL upgrade, clients receive ERROR 2026 (HY000): SSL connection error
search cancel

After MySQL upgrade, clients receive ERROR 2026 (HY000): SSL connection error

book

Article ID: 373584

calendar_today

Updated On:

Products

VMware Tanzu Application Service VMware 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
  • Disable TLS encryption with `int ssl_mode = SSL_MODE_DISABLED; mysql_options(m_handle, MYSQL_OPT_SSL_MODE, &ssl_mode);