How to connect to a MySQL Database without SSL

Question

I'm trying to connect to a local MySQL DB.

I have this connector:

using(MySqlConnection conn = new MySqlConnection("Database=Studentenverwaltung;Port=3306;Data Source=127.0.0.1;User Id=root;Password=abc123")) 
{
    try 
    {
        conn.Open();
        Console.WriteLine("Opened!");
        conn.Close();
    }
    catch(Exception e) 
    {
        Console.WriteLine("Cannot open Connection");
        Console.WriteLine(e.ToString());
    }
}

But I get this Exception:

MySql.Data.MySqlClient.MySqlException (0x80004005): The host 127.0.0.1 does not support SSL connections.

It seems that it cannot connect to the DB because the DB doesn't support SSL. So is there a way how to connect to the DB whithout SSL?

Guido Leenders · Accepted Answer · 2020-08-24 15:29:57Z

32

Have you tried to set the SslMode property to 'none' in your connection string?

This should work:

new MySqlConnection("Database=Studentenverwaltung;Port=3306;Data Source=127.0.0.1;User Id=root;Password=abc123;SslMode=none;")

edited Aug 24, 2020 at 15:29

Guido Leenders

4,2832 gold badges25 silver badges44 bronze badges

answered May 27, 2018 at 17:14

Kjell Derous

5011 gold badge5 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Himalaya Garg Over a year ago

Is there any security concern by doing this setting?

Camway Over a year ago

If you have any security concerns at all, please never do this. Ever. For any reason... Ever

Adzislaw · Accepted Answer · 2019-03-04 13:42:42Z

using MySql.Data.MySqlClient;

private const String SERVER = "1.1.1.1";         // Server IP
private const String DATABASE = "abc";           // Date base name
private const String TABLE = "test";             // Table name
private const String UID = "user";               // Date base username
private const String PASSWORD = "pass";          // Date base password

public static void InitializeDataBase()
{                
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();

builder.Server = SERVER;
builder.UserID = UID;
builder.Password = PASSWORD;
builder.Database = DATABASE;
builder.SslMode = MySqlSslMode.None;
//builder.CertificateFile = @"<Path_To_The_File>\client.pfx";
//builder.CertificatePassword = "<Password_For_The_Cert>";

String connString = builder.ToString();
builder = null;

dbConn = new MySqlConnection(connString);         
}

Collectives™ on Stack Overflow

How to connect to a MySQL Database without SSL

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related