【问题处理】navicat或Sequel Pro连接mysql connection failed

【问题】本地连接mysql失败，报错

Unable to connect to host 127.0.0.1, or the request timed out.

Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).

MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found

【原因】

mysql 8+更新了密码验证机制，我的navicat或Sequel Pro不是比较新的版本，不支持caching_sha2_password插件。

【处理】

更新数据库客户端navicat或Sequel Pro。

我开始用的Sequel Pro，然后直接下载了个最新的navicat，就可以了。