C#客户端连接Mysql 出错：Authentication to host '192.168.1.188' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.

1.C# Mysql.data.dll连接Mysql数据库

2.Mysql 版本5.6

3.客户端connection.open();出错如下：

Authentication to host '192.168.1.188' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.

处理：

Mysql 修改用户权限

1.grant all privileges on *.* to root@'192.168.1.188' identified by '密码' with grant option;
2.FLUSH PRIVILEGES;