c# - Why MySQL throws Exception when I launch my program first time: Error reading from the stream

Question

Authentication to host '127.0.0.1' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed. I've searched a lot about this issue and only Internet disconnect solved the problem. Why is that?

I use MYSQL 8 and C# winforms.

Connection code looks like this:

MySqlConnection conn = new MySqlConnection("datasource=127.0.0.1;username=root;password=password;database=my_tests");

The every next try I execute the command is successful! It happens only first time.

I very appreciate your time people. And would be very thankful for constructive help for a newbie like me.

question from:https://stackoverflow.com/questions/65626584/why-mysql-throws-exception-when-i-launch-my-program-first-time-error-reading-fr

Answer 1

When I put SslMode=None to a string so it looks like

MySqlConnection conn = new MySqlConnection("datasource=127.0.0.1;username=root;password=password;database=my_tests;SslMode=None");

the problem is gone. But I'm not sure if I want not to use it. Any other solutions would be great.