ERROR 2026 (HY000): SSL connection error — The Solution

If you’re using mysql server with SSL, and ever encountered this error whenever you try to access the database after it’s running:

ERROR 2026 (HY000): SSL connection error

One thing to check is if your client certificate and server certificate have the same common name. You’ve probably went through the certificate generation procedure, and (like I did) just entered the same common name for both without noticing.

This is a nasty error message that doesn’t tell you anything, and there’s nothing in the error log to imply what went wrong. So remember – when generating your own certificates for a mysql server, use different common names for client and server!

About these ads

6 thoughts on “ERROR 2026 (HY000): SSL connection error — The Solution

  1. Uh, why is this THE solution? It is one thing to check, sure, but I am having the problem and I did not make that mistake.

  2. I was setting zmanda backup and ran into this issue and that’s exactly what happened to me as well. Definitely pays to look at these things closely sometimes. But it would be good if mySQL gave a more descriptive error.

    Anyway, thanks for posting this it has saved me hours or days!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s