Error connecting to MySQL

[Tim]

I'm trying to add a SQL Data Source which uses the MySQL Data Provider. When I enter the Connection string it displays the error:

Connection unsuccessful. Check the connection string and try again. Details: SSL Connection error.

 

The connection string should work because I copied from an appsettings.json file. I can also use the server name, user, and password in the connection string to connect with HeidiSQL successfully. Is there any way to find more information about the error?

Under Windows Logs, there are several Application Warnings that look like this:

Aborted connection 1747 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)

Not sure why this error is happening at the same time as those are not the values for db, user, and host that I'm using. The connection string looks like this:

Server=Juneau;Database=live_ztj;User=John;Password=OldTim3r#;ConvertZeroDateTime=true;

Thanks,

Tim

[Tim]

Once 'SslMode=None;' was added to the end of the connection string, it worked fine.