Navicat连接MySQL8.0版本时出现Client does not support authentication protocol requested by server；报错的问题解决办法

Mac系统下  遇到 Navicat连接MySQL8.0版本时出现Client does not support authentication protocol requested  by server；报错的问题解决办法

报错：Client does not support authentication protocol requested 

by server; consider upgrading MySQL client

大部分童鞋会选择尝试许多博友推荐的如下常见方式来解决：（我也尝试过）

其一: 
mysql> SET PASSWORD FOR 
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); 
其二: 
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') 
-> WHERE Host = 'so