Authentication to host ‘地址’ for user ‘账户’ using method ‘mysql_native_password’ failed with message: Reading from the stream has failed
“/”应用程序中的服务器错误。
尝试读取超出流末尾的内容。
说明: 执行当前 Web 请求期间,出现未经处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.IO.EndOfStreamException: 尝试读取超出流末尾的内容。
源错误:
执行当前 Web 请求期间生成了未经处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。
堆栈跟踪:
[EndOfStreamException: 尝试读取超出流末尾的内容。]
MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) +111
MySql.Data.MySqlClient.MySqlStream.LoadPacket() +73
[MySqlException (0x80004005): Reading from the stream has failed.]
MySql.Data.MySqlClient.MySqlStream.LoadPacket() +344
MySql.Data.MySqlClient.MySqlStream.ReadPacket() +38
MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket() +40
[MySqlException (0x80004005): Authentication to host ‘’ for user ‘’ using method ‘mysql_native_password’ failed with message: Reading from the stream has failed.]
MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex) +215
MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket() +109
MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) +387
MySql.Data.MySqlClient.NativeDriver.Open() +779
MySql.Data.MySqlClient.Driver.Open() +61
MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) +313
MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() +18
MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() +303
MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() +142
MySql.Data.MySqlClient.MySqlPool.GetConnection() +57
MySql.Data.MySqlClient.MySqlConnection.Open() +1199
lambda_method(Closure , ControllerBase , Object[] ) +191
System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary2 parameters) +204
解决办法:在数据库连接字符串中给他加上"SslMode=none",让他指定SSL模式,mysql5.7 及以上版本数据默认开启SSL,连接时需要指明
原先的连接数据库字符串:< add name=“mysql” connectionString=“Data Source=127.0.0.1;port=3306;Initial Catalog=数据库名字;uid=账户;password=密码;Charset=utf8;” providerName=“MySql.Data.MySqlClient” />
然后现在的是:< add name=“mysql” connectionString=“Data Source=127.0.0.1;port=3306;Initial Catalog=数据库名字;uid=账户;password=密码;Charset=utf8;SslMode=None” providerName=“MySql.Data.MySqlClient” />
参考链接:http://www.z-xl.top/?p=229