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

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

Are you on the latest v11.1?

Did you also try the other library libmariadb.dll?

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)"

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.

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?

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\

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?

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?

I am experiencing the same issue while connecting to Digital Ocean managed MySQL server. I tried to replace libmysql.ddl from MySQL server installation, but it didnt help. I get "Access denied for user 'xxx'#'x.x.x.x' (using password: YES)" while using libmariadb.dll and SSL connection error: error: 1416F086:SSL routines:tls_process_server_certificate: certificate verify failed while using libmysql.dll (I tried to provide SSL CA file as well).

Same issue while connecting to a remote server with ssh tunnel : Access denied for user 'xxx'#'x.x.x.x' (using password: YES) suddenly (friday works, monday no)

Solved replacing plink.exe with last version

Why? no idea...