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