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

dmikester1's profile image dmikester1 posted 4 years 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 4 years ago Permalink

Are you on the latest v11.1?

Did you also try the other library libmariadb.dll?

dmikester1's profile image dmikester1 posted 4 years 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 4 years 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 4 years 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 4 years 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 4 years 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 4 years 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?

danpospisil's profile image danpospisil posted 4 years ago Permalink

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

pit1024's profile image pit1024 posted 4 years ago Permalink

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...

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