2024年4月29日发(作者：)

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

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 "" (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运行""

【计算机配置】中找到【管理模板】-【Internet通信设置】，

右键【关闭自动根证书更新】-点击【编辑】-改为【已启用】。

更改完毕后，是立即生效的。

再次运行安装程序：

server安装成功！

记得把sampling and examples也reconfigure/安装下，因为需要输入root密码。