with Query Tool Beta 20.1.529, the connection to one of my MySQL servers does not work anymore. It was working fine with a previous version 20.1.4xx but not sure of which one.
I do no connect very often to this MySQL server, so I’m unsure on what version I was running before upgrading to 20.1.529 due to Exact Online API summer festivities.
Een verbinding met de database ‘Port Adhoc\darwin+SQL’ kon niet worden opgebouwd als gebruiker ‘’.
The data container with alias ‘Darwin’ could not be opened on provider ‘MySql’.
SSL Connection error.
Bericht ID: c914c4a3-25fa-4745-a5c0-ac51fb794bac
Opgetreden (UTC): 31/08/2021 16:31:17
à System.Net.Security.SslState.InternalEndProcessAuthentication(LazyAsyncResult lazyResult)
à System.Net.Security.SslState.EndProcessAuthentication(IAsyncResult result)
1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action
1 endAction, Task1 promise, Boolean requiresSynchronization)
Obviously there is an issue with SSL given “SSL Connector error”. My database definition is:
<database order="14" provider="MySql" alias="Darwin" userLogonCodeMode="Hidden" passwordMode="Hidden" AllowConnectionPooling="false" connectionString="Server=myserver.com;Port=3306;Database=mydatabase;User Id=MyuserId;Password=thisisapassword;SslMode=Preferred" AllowConnectionStringRewrite="false" />
I’m sure my server is not SSL capable (getting rid of the server anytime soon !). It seems Query Tool does like
SslMode=Preferred, not wanting to switch to no SSL connection if SSL is not supported.
I did not found in the MySQL support forums that a
noSSL mode could exist.
How can I connect to this MySQL database again?