Connect to MySQL using SSL in C#

Question

I'm connecting to a MySQL server that requires SSL, using a MySqlConnection:

var connection = new MySqlConnection("Data Source=127.0.0.1;Database=MyDb1;User Id=root;Password=blabla;encrypt=true");

This succeeds if the server doesn't require SSL, but after executing GRANT USAGE ON *.* TO 'root'@'localhost' REQUIRE SSL; on the server, it starts failing with:

ProviderIncompatibleException: The provider did not return a ProviderManifestToken string. ---> MySql.Data.MySqlClient.MySqlException: Authentication to host '127.0.0.1' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'localhost' (using password: YES) ---> MySql.Data.MySqlClient.MySqlException: Access denied for user 'root'@'localhost' (using password: YES)

How is SSL enabled? Should something be added to the connection string or is it done programmatically?

sashoalm · Accepted Answer · 2023-11-13 09:35:42Z

7

OK, after some more searching I found the answer at How determine if using SSL in a MySql Connection?.

I had to add SSL Mode=Required instead of encrypt=true to the connection string:

var connection = new MySqlConnection("SSL Mode=Required;Data Source=127.0.0.1;Database=MyDb1;User Id=root;Password=blabla");

Now I'm getting a new error - MySql.Data.MySqlClient.MySqlException: “The host localhost does not support SSL connections.”, but I think I'll figure it out.

edited Nov 13, 2023 at 9:35

answered Oct 3, 2017 at 10:49

sashoalm

80.5k138 gold badges485 silver badges830 bronze badges

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

Comments

Ihdina · Accepted Answer · 2023-11-13 12:25:25Z

This connecting string work for me with MySQL Comunity Server 8.0.35.

Look at here to generate SLL Certificates for MySQL Server (*.pem) and for C# Client (client.pfx)
I use connString like this:

String connString = "server=localhost;
                     user id=root;
                     database=YOUR_DB_NAME;
                     persistsecurityinfo=True;
                     password=YOUR_DB_PASSWORD;
                     allowuservariables=True;
                     allowbatch=True;
                     sslmode=Required;
                     certificatepassword=YOUR_PFX_CERTIFICATE_PASS;
                     certificatefile=YOUR_PFX_CERTIFICATE_FILE;"

Example

 YOUR_DB_NAME = discount_card
 YOUR_DB_PASSWORD = db_p455w0rd
 YOUR_PFX_CERTIFICATE_PASS = pfx_p455w0rd
 YOUR_PFX_CERTIFICATE_FILE = D:\\certificates\\client.pfx

Murali Raja · Accepted Answer · 2018-07-26 03:27:40Z

-2

var connection = new MySqlConnection("Data Source=127.0.0.1;Database=MyDb1;User Id=root;Password=blabla;SSL Mode=None");

For me Working Fine...

answered Jul 26, 2018 at 3:27

Murali Raja

431 bronze badge

2 Comments

Camway Over a year ago

For anyone looking for an answer to this question, this is not it. As you can see, the question is how to use SSL, not how to disable it.

Daniel Wu Over a year ago

Scary how this is positioned at the top, when it simply ignores SSL

Adrian · Accepted Answer · 2021-08-08 10:02:59Z

-2

You can use this in your connection string.

 SSL Mode=0

answered Aug 8, 2021 at 10:02

Adrian

1

Comments

NONABA · Accepted Answer · 2022-07-20 11:56:46Z

-2

You can try with another user like 'User1@%' or '[email protected]' I hope that can help you

answered Jul 20, 2022 at 11:56

NONABA

11 bronze badge

1 Comment

Pashyant Srivastava Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Connect to MySQL using SSL in C#

5 Answers 5

Comments

Comments

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related