using method 'mysql_native_password' failed with message

发布时间 2023-05-09 14:53:25作者: 晓周的园子
  1. 错误消息:Connection open error . Authentication to host '10.114.129.206' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.DbType="MySql";ConfigId=""
  2. 解决方法:在连接字符串里添加:SslMode=None;
  1. 错误消息:Authentication to host '10.114.129.206' for user 'root' using method 'mysql_native_password' failed with message: Got timeout reading communication packetsDbType="MySql";ConfigId=""
  2. 解决方法:

    <add name="ConnectionString" connectionString="server=10.xxx.xxx.xxx;port=3306;user id=root;password=xxxx;database=jyc;persistsecurityinfo=True;ConvertZeroDateTime=true;AllowUserVariables=True;SslMode=None;" providerName="MySql.Data.MySqlClient" xdt:Transform="Replace" xdt:Locator="Match(name)"/>