MySql.Data.MySqlClient.MySqlException: “The host localhost does not support SSL connections.”
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?
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)
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);