mysql报错Unable to load authentication plugin ‘caching_sha2_password‘.

最新推荐文章于 2025-02-28 12:05:40 发布

syty2020

最新推荐文章于 2025-02-28 12:05:40 发布

阅读量314

点赞数

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/dzhou1991/article/details/116789387

版权

MySQL caching_sha2_password 密码修改 dbeaver 权限设置

关键词由优快云通过智能技术生成

mysql 专栏收录该内容

2 篇文章

订阅专栏

本文讲述了如何解决MySQL中'caching_sha2_password'插件无法加载的问题，包括修改密码和配置过程，以及解决后使用DBeaver连接的提示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql报错

Unable to load authentication plugin 'caching_sha2_password'.

如下输入命令修改；密码修改为自己的；123456是自己的

 
D:\software\mysql-8.0.23-winx64\bin>mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 8.0.23 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

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.

mysql> alter user 'root' @'localhost' identified with mysql_native_password by '123456'
    ->
    -> ;
Query OK, 0 rows affected (0.01 sec)

mysql> use mysql
Database changed
mysql> select user,host,plugin from user;
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session    | localhost | caching_sha2_password |
| mysql.sys        | localhost | caching_sha2_password |
| root             | localhost | mysql_native_password |
+------------------+-----------+-----------------------+
4 rows in set (0.00 sec)

mysql> select user,host,plugin from user;

再次打开dbeaver就可以用了