Mysql8.0.21 Community Server远程连接报错

爱摄影的程序员。

于 2020-08-26 17:52:46 发布

阅读量521

点赞数

分类专栏： Mysql专栏文章标签： mysql 数据库 linux centos

本文链接：https://blog.youkuaiyun.com/php_xml/article/details/108244629

版权

在Linux CentOS系统中，尝试远程连接MySQL 8.0.21 Community Server时，出现ERROR 2059 (HY000)错误，原因在于认证插件'caching_sha2_password'未能加载。为解决此问题，可以在MySQL客户端中执行一系列命令进行修复。

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

--------------
mysql  Ver 14.14 Distrib 5.6.15, for linux-glibc2.5 (x86_64) using  EditLine wrapper

Connection id:		23
Current database:	
Current user:		root@120.25.122.113
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		8.0.21 MySQL Community Server - GPL
Protocol version:	10
Connection:		106.52.164.170 via TCP/IP
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8
Conn.  characterset:	utf8
TCP port:		3306
Uptime:			8 hours 46 min 43 sec

Threads: 3  Questions: 98  Slow queries: 0  Opens: 237  Flush tables: 3  Open tables: 158  Queries per second avg: 0.003
--------------