Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

SSL Connection Error: unknown error number, Please select a different library

dmikester1's profile image dmikester1 posted 3 weeks ago in General Permalink

I am trying to connect to our MySQL server out on Digital Ocean. I am getting the following error: SSL Connection Error: unknown error number, Please select a different library in your session settings. (Current: "libmysql.dll")

I am doing this from a Windows 10 desktop. And the MySQL server says version 8.0.20 compiled for Linux (x86_64).

I was able to input the same connection settings into MySQL Workbench and it connected fine. I much prefer HeidiSQL though. But in Workbench, I did run the query: "SHOW SESSION STATUS LIKE 'Ssl_version'" and got back "TLSv1.2" because I read that was helpful in one of the threads.

Any help would be much appreciated. Thanks Mike

ansgar's profile image ansgar posted 3 weeks ago Permalink

Are you on the latest v11.1?

Did you also try the other library libmariadb.dll?

dmikester1's profile image dmikester1 posted 3 weeks ago Permalink

I am on the latest v11.1, just updated it today. And when I try and switch to libmariadb.dll, I get the error: "Access denied for user 'xxx'#'x.x.x.x' (using password: YES)"

ansgar's profile image ansgar posted 3 weeks ago Permalink

Welcome to the world of SSL issues :)

Did you also try the newer libmysql-6.1.dll ?

If nothing helps, you could try a libmysql from the MySQL 8 server package.

dmikester1's profile image dmikester1 posted 3 weeks ago Permalink

Yep, I did that that one as well. Got the same: "SSL Connection Error: unknown error number, Please select a different library in your session settings. "

Can you tell me how to try one from the MySQL 8 server package?

ansgar's profile image ansgar posted 3 weeks ago Permalink

Yes, just download the Windows version of the MySQL server from mysql.com . If it's an installer, there should be a libmysql.dll somewhere in C:\Progam Files\MySQL\

dmikester1's profile image dmikester1 posted 2 weeks ago Permalink

I already have MariaDB installed and it won't let me install MySql 8 for some reason. I'm trying to download the dll from here: https://www.dll-files.com/libmysql.dll.html Any ideas which one I should download?

dmikester1's profile image dmikester1 posted 2 weeks ago Permalink

OK, I was able to finally download a zip package of MySQL so can grab the libmysql.dll from that. So I went to C:\Program Files (x86)\Common Files\MariaDBShared\HeidiSQL and found the old dll. I renamed it by putting .bak at the end. Then I copied over the new dll from the zip file I downloaded. Then I restarted HeidiSQL. Still getting the same error though. Did I do all of that right?

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.