MYSQL安装过程报错，怎么解决？MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'caching_sha2_password' failed with message: Reading from the stream has failed.
安装MySQL server时，Creating uer accounts时报错：
Attempting to start
Successfully started service MySQL80.
Waiting until a connection to MySQL Server 8.0.20 can be established (with a maximum of 10 attempts)...
Retry 1: Attempting to connect to Mysql@localhost:3306 with user root with
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'caching_sha2_password' failed with message: Reading from the stream has failed.
Waiting 5 seconds before the next
简述安装mysql的过程Retry 2: Attempting to connect to Mysql@localhost:3306 with user root with
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'caching_sha2_password' failed with message: Reading from the stream has failed.
Waiting 5 seconds before the next
Retry 3: Attempting to connect to Mysql@localhost:3306 with user root with
Beginning configuration step: Creating user accounts
Attempting to Add New MySQL Users
An error occurred trying to add new users to the MySQL database (see log).
Ended configuration step: Creating user accounts
【解决方案】
1. Press Win+R to open the "Run" dialog
2. Type "gpedit.msc" (without quotes) and press Enter
3. In the "Local Group Policy Editor", expand "Computer Configuration", expand "Administrative Templates", expand "System", expand "Internet Communication Management", and then click "Internet Communication settings".
4. In the details panel, double-click "Turn off Automatic Root Certificates Update", clickEnabled, then click OK. This change will be effective immediatelly without restart.
After that, the repair task for the aborted Update went through.
分步骤截图：
Cmd运行"gpedit.msc"
【计算机配置】中到【管理模板】-【Internet通信设置】，
右键【关闭自动根证书更新】-点击【编辑】-改为【已启用】。
 
 
 
 更改完毕后，是立即生效的。
 再次运行安装程序：
 
 server安装成功！
 
 记得把sampling and examples也reconfigure/安装下，因为需要输入root密码。
 

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。