怎么解决C# Mysql.data.dll Authentication Failed错误

Question

怎么解决 C#通过Mysql.data.dll 查询MySQL数据库报 Authentication to host '192.168.1.28' for user 'etl' using method 'mysql_native_password' failed with message: Reading from the stream has failed. 异常

Answer 1

权限问题吧，MySql 默认只支持从 127.0.0.1 / localhost 访问。你这个 etl 的用户开启了允许远程访问的权限吗？

如果没有，百度 MySql 开启远程访问，随便找一篇跟着设置就好了。