2059 - Authentication plugin 'caching_sha2_password' cannot be loaded

梦里梦外; 2022-03-12 05:25 379阅读 0赞

## 本地之前有数据库，后来装了mysql8.0 导致本地连接不上去 ##

![20180612021422331][]

可以通过mysql自带的命令行工具 进入mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NDIzMTA1_size_16_color_FFFFFF_t_70][]

1 选择数据库mysql

mysql> use mysql
    Database changed
    mysql> select user,host,plugin,authentication_string from user;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NDIzMTA1_size_16_color_FFFFFF_t_70 1][]

2 更改加密方式

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
    Query OK, 0 rows affected (0.10 sec)

3 更改密码

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

4 刷新权限

mysql> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.28 sec)

再次连接ok!!!

[20180612021422331]: /images/20220312/7b9ed7bcb79d4880815dff10e9ed8f81.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NDIzMTA1_size_16_color_FFFFFF_t_70]: /images/20220312/e2e2715becbc43dc95957d95c47eab9a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NDIzMTA1_size_16_color_FFFFFF_t_70 1]: /images/20220312/0ad245235bac472ba148817dc689f8b3.png