这篇博客介绍了在遇到使用SQLyog连接MySQL8.0时出现的Error No.2058问题，原因是MySQL8.0引入了新的密码认证方式caching_sha2_password。提供了两种解决方案：一是修改用户密码和加密方式；二是更改my.ini配置文件，将默认密码规则设回mysql_native_password，并执行权限刷新及重置root密码。
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:MySQL8以前版本使用的密码加密规则是mysql_native_password
MySQL8使用的密码加密规则是caching_sha2_password
方法一：修改用户密码和加密方式
use mysql
ALTER USER 'root'@'localho
最低0.47元/天 解锁文章
1298
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
