Mysql连接报错：mysql_native_pas5word.failed

错误：Authentication to host '127.0;0.1’for user 'root’usingmethod 'mysql_native_pas5word.failed with message : Reading fromthe stream has failedo

解决方案1：

添加SslMode=None

server=127.0.0.1;Database=xxx;port=3306;User ID=xxxx;Password='xxxxx';charset=utf8;Allow User Variables=True;SslMode=None        

解决方案2：

找到开始菜单下mysql目录下的cmd程序，如图：

use mysql
update mysql.user set plugin='mysql_native_password' where user='root';
FLUSH PRIVILEGES;
select host,user,plugin from mysql.user;