Error connecting to MySQL

1 Answer 54 Views
DataSource SQL
Tim
Top achievements
Rank 1
Iron
Veteran
Iron
Tim asked on 29 Jul 2021, 02:15 AM

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

1 Answer, 1 is accepted

Sort by
0
Tim
Top achievements
Rank 1
Iron
Veteran
Iron
answered on 29 Jul 2021, 03:02 PM
Once 'SslMode=None;' was added to the end of the connection string, it worked fine.
Tags
DataSource SQL
Asked by
Tim
Top achievements
Rank 1
Iron
Veteran
Iron
Answers by
Tim
Top achievements
Rank 1
Iron
Veteran
Iron
Share this question
or