在MySQL8中尝试重置忘记根密码时出错吗？

Question

我尝试了大多数在线.But上可用的故障排除步骤，我没有得到解决方案，我忘记了我的根密码.I尝试创建init文件并加载联机数据，并使用cmd提示符.Then尝试使用更新命令删除密码

错误快照-> https://i.stack.imgur.com/tfFR6.jpg

(c) 2019 Microsoft Corporation. All rights reserved.

C:\Users\chitr>cd C:\Program Files\MySQL\MySQL Server 8.0\bin

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld.exe -u root --skip-grant-tables
2019-11-11T18:39:05.755671Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.18) starting as process 11668
2019-11-11T18:39:05.758635Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2019-11-11T18:39:05.758740Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2019-11-11T18:39:05.758887Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'C:\Program Files\MySQL\MySQL Server 8.0\data\' (OS errno: 2 - No such file or directory)
2019-11-11T18:39:05.777215Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-11-11T18:39:05.777347Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql --version
mysql  Ver 8.0.18 for Win64 on x86_64 (MySQL Community Server - GPL)

C:\Program Files\MySQL\MySQL Server 8.0\bin>sudo systemctl stop mysql.service
'sudo' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\MySQL\MySQL Server 8.0\bin>sudo /etc/init.d/mysql stop
'sudo' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --console
2019-11-11T18:58:41.814544Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.18) starting as process 10004
2019-11-11T18:58:41.817402Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2019-11-11T18:58:41.817505Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2019-11-11T18:58:41.817645Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'C:\Program Files\MySQL\MySQL Server 8.0\data\' (OS errno: 2 - No such file or directory)
2019-11-11T18:58:41.833930Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-11-11T18:58:41.834045Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld  --init-file=C:\Program Files\MySQL\MySQL Server 8.0\bin --console
2019-11-11T18:59:31.764265Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.18) starting as process 13568
2019-11-11T18:59:31.767450Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2019-11-11T18:59:31.767595Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2019-11-11T18:59:31.767780Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'C:\Program Files\MySQL\MySQL Server 8.0\data\' (OS errno: 2 - No such file or directory)
2019-11-11T18:59:31.788066Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-11-11T18:59:31.788210Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -p
Enter password: **********
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)```


  [1]: https://i.stack.imgur.com/tfFR6.jpg

Answer 1

你也应该发布你使用的教程。

从您的日志中可以看出，这似乎适用于linux。

对windows使用这个简单的解决方案

https://dev.mysql.com/doc/mysql-windows-excerpt/8.0/en/resetting-permissions-windows.html

然后按照信写下去。

Answer 2

在mysql安装文件夹中手动创建“data”文件夹似乎是可行的。这就是错误的意思，它不能写入数据文件夹，很可能是因为它不存在。

这是个老生常谈，但我只是遇到了同样的问题。

Answer 3

这个问题归结为管理员特权。(I)不要在windows中使用sudo命令。关闭命令提示符窗口，然后作为管理员运行一个新的窗口，并按照这里突出显示的正确过程：https://dev.mysql.com/doc/mysql-windows-excerpt/8.0/en/resetting-permissions-windows.html