Tag Archives: for user ‘root’ using method ‘mysql_native_password’ failed with message: Reading from the stream has failed

[Solved] for user ‘root’ using method ‘mysql_native_password’ failed with message: Reading from the stream has failed

Add to the connection string:SslMode=None;

 

Example:

<add name=”dvaContext” connectionString=”server=192.168.0.106;port=3306;user id=root;password=123456;database=santou;persistsecurityinfo=True;ConvertZeroDateTime=true;AllowUserVariables=True;SslMode=None;” providerName=”MySql.Data.MySqlClient” />