解决SQLyog连接报错 Error No.2058 Plugin caching_sha2_password could not be loaded

最新推荐文章于 2025-06-27 20:54:23 发布

原创

最新推荐文章于 2025-06-27 20:54:23 发布 · 956 阅读

3 ·

CC 4.0 BY-SA版权

这篇博客介绍了在遇到使用SQLyog连接MySQL8.0时出现的Error No.2058问题，原因是MySQL8.0引入了新的密码认证方式caching_sha2_password。提供了两种解决方案：一是修改用户密码和加密方式；二是更改my.ini配置文件，将默认密码规则设回mysql_native_password，并执行权限刷新及重置root密码。

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

MySQL8.0新的密码认证方式

The caching_sha2_password and sha256_password authentication plugins provide more secure password encryption than the mysql_native_password plugin, and caching_sha2_password provides better performance than sha256_password. Due to these superior security and performance characteristics of caching_sha2_password, it is as of MySQL 8.0 the preferred authentication plugin, and is also the default authentication plugin rather than mysql_native_password. This change affects both the server and the libmysqlclient client library:

Changes in MySQL 8.0

MySQL8以前版本使用的密码加密规则是mysql_native_password

MySQL8使用的密码加密规则是caching_sha2_password

方法一：修改用户密码和加密方式

use mysql 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mys

最低0.47元/天解锁文章

200万优质内容无限畅学