MySql.Data.MySqlClient.MySqlException: “The host localhost does not support SSL connections.”

C#Mysqlasp.net Coremysql.data

C# Problem Overview

I use MySql.Data 8.08 and .NET Core to connect to MySql 5.7.18 but following exception is being thrown:

MySql.Data.MySqlClient.MySqlException:“The host localhost does not support SSL connections.”

How to deal with it?

C# Solutions

Solution 1 - C#

I had the same problem today when moving from MySql.Data 7.0.7 to 8.0.8. I was able to move forward adding the "SslMode=none" in the connection string.

You will endup with something like:

server={0};user id={1};password={2};persistsecurityinfo=True;port={3};database={4};SslMode=none

(replacing the values with your database details)

Solution 2 - C#

And if you using a connection pool class, then you might have to do this way:

    string connstring = string.Format("Server=44.55.110.59; database={0}; UID=root; password=Newuser@123; SslMode = none", databaseName);
Categories
Recommended C# Solutions
Recommended Mysql Solutions
Recommended asp.net Core Solutions

Previous Solution:

How do I fix "Expected to return a value at the end of arrow function" warning?

JavascriptReactjsEcmascript 6ReduxReact Redux

Next Solution:

How to mock functions in the same module using Jest?

JavascriptTestingMockingJestjs

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionSeaView Question on Stackoverflow
Solution 1 - C#JDCView Answer on Stackoverflow
Solution 2 - C#AnujView Answer on Stackoverflow