navicat 连接 mysql 出现Client does not support authentication protocol requested by server解决方案

今天安装了navicat 和 mysql，结果最后在navicat中连接mysql时，出现了如下错误提示：

Client does not support authentication protocol requested by server; consider upgrading MySQL client

网上找了如下方法：

1. 其一:

mysql> SET PASSWORD FOR
     -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

2. 其二:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')

    -> WHERE Host = 'some_host' AND User = 'some_user';

mysql> FLUSH PRIVILEGES;

上面some_user、some_host、newpwd按自己实际情况修改

但是自己尝试了之后依旧有错误提示，最后尝试了如下方法恢复正常：

USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '831015';
FLUSH PRIVILEGES;

root是用户名，localhost是ip地址127.0.0.1都是特指本机，mysql_native_password是旧的密码验证机制，831015是密码，最后别忘了分号；

最后问题解决：

感谢贴吧17楼大神：http://tieba.baidu.com/p/5658058140