mysql8 dbeaver sha2_dbeaver连接mysql8提示不能加载caching_sha2_password

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

```

参考：

[https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded](https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/69956102/viewspace-2722117/，如需转载，请注明出处，否则将追究法律责任。