Navicat Premium 连接MySQL数据库出现Authentication plugin 'caching_sha2_password' cannot be loaded的解决方案

Navicat Premium 连接MySQL数据库出现Authentication plugin ‘caching_sha2_password’ cannot be loaded的解决方案

Navicat Premium安装了很久了，有段时间没使用，最近想重拾数据库，尝试用Navicat Premium创建一个链接，“Test connection”时提示“Authentication plugin ‘caching_sha2_password’ cannot be loaded”，百度了一阵，找到了方法，记录下供学习参考。

解决方法：
MacOS下：
1、cd到mysql的bin目录下面，Mac默认是/usr/local/mysql
执行命令：mysql -u root -p
Enter password:
输入正确密码：
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 36
Server version: 8.0.12 MySQL Community Server - GPL
Copyright © 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a regist