How to connect to a MySQL Database without SSL
19,692
Solution 1
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;")
Solution 2
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);
}
Author by
Stefan
Updated on June 05, 2022Comments
-
Stefan almost 2 years
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?
-
Himalaya Garg over 2 yearsIs there any security concern by doing this setting?
-
Camway over 2 yearsIf you have any security concerns at all, please never do this. Ever. For any reason... Ever