mosar Posted January 3, 2018 Share Posted January 3, 2018 (edited) 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 Quote Link to comment Share on other sites More sharing options...
wolstech Posted January 3, 2018 Share Posted January 3, 2018 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. Quote Link to comment Share on other sites More sharing options...
mosar Posted January 3, 2018 Author Share Posted January 3, 2018 My bad, thank you, that solved it. Quote Link to comment Share on other sites More sharing options...
Luigi123 Posted January 3, 2018 Share Posted January 3, 2018 Let us know if you need any help or have any questions. Quote Link to comment Share on other sites More sharing options...
Krydos Posted January 3, 2018 Share Posted January 3, 2018 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. Quote Link to comment Share on other sites More sharing options...
miwilc Posted January 3, 2018 Share Posted January 3, 2018 @Krydos it must be showing as MySQL: SSL enabled to the program then. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.