无法在Windows上重新安装MySql“无法用给定密码连接到MySql”。忘记根密码

Question

我在学习春季批次。我按照说明在Windows11上安装MySQL Shell 8.0.26和Workbench 8.0。

不管我得到了什么

MySQL  JS > alter user 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'password';
SyntaxError: Unexpected identifier
 MySQL  JS > show schemas;
SyntaxError: Unexpected identifier
 MySQL  JS > show databases;

因此，我试图卸载和重新安装MySql。当我运行安装程序时，

​

​

我忘记了根密码。我该怎么办？

在这个similar中，所以提问者记住了密码。

我做了一个网络搜索，并试图遵循这里的步骤。

https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

C:\Program Files\MySQL\MySQL Server 8.0\bin>.\\mysqld --init-file=C:\\Documents\\mysql-init.txt
2021-11-15T00:37:15.052478Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.26) starting as process 5260
2021-11-15T00:37:15.054496Z 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
2021-11-15T00:37:15.054535Z 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
2021-11-15T00:37:15.054651Z 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)
2021-11-15T00:37:15.056382Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-11-15T00:37:15.056496Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.26)  MySQL Community Server - GPL.

C:\Program Files\MySQL\MySQL Server 8.0\bin>

Answer 1

我找到了这篇文章，它说必须手动删除以下文件夹。仅仅从Windows控制面板卸载是不够的。

C:\Program Files\MySQL

C:\Program Files (x86)\MySQL

C:\ProgramData\MySQL

https://answers.microsoft.com/en-us/windows/forum/windows_other-windows_programs/how-to-completely-uninstall-mysql/e90e1344-7b90-4319-8b2f-77b271ae66ed

我遵循步骤，当我再次运行安装程序，它要求一个新的根密码！