Mysql出现问题

MySql.Data.MySqlClient.MySqlException: Client does not support authentication protocol requested by server; consider upgrading MySQL client

解决这个问题只要一个关键信息“authentication”，出现这个异常通常是用户不存在或密码错误。所以，可以这样解决：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword';

或者

CREATE USER 'foo'@'%' IDENTIFIED WITH mysql_native_password BY 'bar';
最后执行，
FLUSH PRIVILEGES;

然后就可能出现

Access denied for user ‘root’@’%’ to database ‘user’

运行命令：mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;