MySQL 8.0.11错误，连接到caching_sha2_password找不到指定的模块 [英] MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found

问题描述

我尝试从MySQL工作台连接到最新的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是您当前的密码.

这篇关于MySQL 8.0.11错误，连接到caching_sha2_password找不到指定的模块的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！