搭建的网站数据库用的是,docker mysql8
本地 dbeaver 连接报错,Unable to load authentication plugin 'caching_sha2_password'.
原因:
mysql 8 uses caching_sha2_password as the default authentication plugin instead of mysql_native_password.
Many mysql drivers haven't added support for caching_sha2_password yet.
解决方式:
- 修改 Mysql sever 配置
- dbeaver 新增mysql8 驱动
以上选择任意一项即可