[Solved] ERROR 2026 (HY000): SSL connection error: protocol version mismatch

[mosar]

When attempting to connect to db I suddenly am now getting the error

ERROR 2026 (HY000): SSL connection error: protocol version mismatch

from the MySQL Workbench or Shell on both of my machines. I was able to connect for several weeks without problems and seemingly for no reason am now getting this error. The last thing I was doing on the server wasn't much special, sth. like "CREATE TABLE IF NOT EXISTS `$tablename` (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY) engine=InnoDB;".

I can access the db just fine using phpMyAdmin

I'm using MySQL Workbench 6.3 CE

I appreciate any suggestions

Edited January 3, 2018 by mosar

[wolstech]

Confirm that you didn't accidentally enable the SSL option in MySQL Workbench. Change the SSL option to "No" instead of "if available."

 

We don't support SSL connections for MySQL.

[mosar]

My bad, thank you, that solved it.

[Luigi123]

Let us know if you need any help or have any questions.

[Krydos]

Just so you know this was a serverside change that caused your error. Another user asked if it was possible to enable mysql ssl connections and after some fiddling I determined it wasn't possible. It was surely the fiddling that made that error pop up.

[miwilc]

@Krydos it must be showing as MySQL: SSL enabled to the program then.