dbeaver连接mysql8提示Unable to load authentication plugin ‘caching_sha2_password‘.
1.通过mysql命令修改加密方式
cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"
C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -u root -p
Enter password: *********
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newrootpassword';
Query OK, 0 rows affected (0.10 sec)
mysql> exit
2.修改mysql配置文件my.ini
修改文件 C:\ProgramData\MySQL\MySQL Server 8.0\my.ini 中以下配置
default_authentication_plugin=mysql_native_password