Mac下使用Navicat连接Mysq2059 - Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen的问题

Mac下使用Navicat连接Mysql时出现以下错误

2059 - Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(../Frameworks/caching_sha2_password.so, 2): image not found

解决办法

$mysql -u root -p
>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';