Mac OS Navicat Premium 使用遇到的坑记录

1. Navicat Premium 连接mysql8.0报:2059 - Authentication plugin ‘caching_sha2_password’ cannot be loaded:

1.报错详情:

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

2.报错图片(摘自网络):

![Alt](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9hdmF0YXIuY3Nkbi5uZXQvNy83L0IvMV9yYWxmX2h4MTYzY29tLmpwZw#pic_c

3.解决方法

1.登陆mysql控制台(可能回遇到command not found命令无效),解决方案在第3点

sudo mysql -u root -p

MacdeMacBook-Pro:~ mac$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.19 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

2.更改密码

mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Query OK, 0 rows affected (0.00 sec)

3.输入mysql -u root -p 出现报错解决方法

command not found
解决方法：修改环境变量

1、输入 sudo vim .bash_profile,输入密码进入文件,按i进入编辑状态,编辑完后按esc 输入:wq保存退出

添加mysql配置信息
在export PATH=$PATH:$MAVEN_HOME/bin后面输入:/usr/local/mysql/bin

export MAVEN_HOME=/Users/oliver/Software/maven/apache-maven-3.6.1
export PATH=$PATH:$MAVEN_HOME/bin:/usr/local/mysql/bin

2.更新刚修改的配置文件

source .bash_profile

参考:
https://blog.csdn.net/u011182575/article/details/80821418
https://blog.csdn.net/qq_38728790/article/details/80625584

PS:仅作自己记录学习使用