MySQL 8.0.11 错误connect to caching_sha2_password 找不到指定的模块
我已经尝试从 MySQL Workbench 连接到最新的 MySQL 服务器 8.0.11,但错误不断弹出:无法连接到 MySQL 服务器,身份验证插件:caching_sha2_password:找不到指定的模块.
I've tried to connect to the latest MySQL server 8.0.11 from MySQL workbench, but the error keeps popping up: Cannot connect to MySQL server, authentication plugin: caching_sha2_password: the specified module could not be found.
我尝试在网上查看MySQL服务器安装视频并准确复制每一步,但错误仍然存在.
I tried looking at MySQL server installation videos online and replicated every step accurately, but the error persists.
非常感谢任何帮助.
推荐答案
我有以下解决方案:像这样在 [mysqld]
部分更改 my.ini :
I had the following solution:
change my.ini in a [mysqld]
section like this:
#default_authentication_plugin=caching_sha2_password (comment line!)
default_authentication_plugin=mysql_native_password (new line)
在命令行客户端中以 root 身份连接到您的 MySQL并执行:
Connect to your MySQL under root in a command line client and execute:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxx';
其中 xxx
是您当前的密码.
Where xxx
is your current password.
相关文章