Mysql8.0.21 Community Server远程连接报错

关注

原创最新推荐文章于 2026-08-28 14:50:55 发布 572 阅读 AI 写同款· GEO 优化 ›

CentOS 8 安装 MySQL 8.0 官方版完整指南 MySQL 是一种广泛使用的关系型数据库管理系统，其安装与配置在不同 Linux 发行版中存在显著差异。CentOS 8 因软件包治理策略调整，默认以 MariaDB 替代 MySQL，导致直接执行 dnf install mysql-server 失败。理解这一生态变迁是解决 'Unit not found'、'Error 2003' 等高频问题的前提。MySQL 8.0 引入 caching_sha2_password 认证插件和严格密码策略，进一步加剧了与旧客户端及系统仓库的兼容性挑战。因此，生产环境阅读详情

--------------
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
--------------

报错提示：

ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
解决：

依次在mysql8中运行如下语句。

show variables like 'default_authentication_plugin';
select host,user,plugin from mysql.user;
update user set host='%' where user='root';
GRANT ALL ON *.* TO 'root'@'%';
alter user 'root'@'%' identified with mysql_native_password by '@6#q111111';

时间：2020年8月26日17:52:40

收录于