Re: 'root' is denied access to all databases/connections

[Phillip Powell]

I am still unable to reset my root password using MySQL 8.0 for Windows 10. I hope I don't have to do the "cold start" solution (uninstall/reinstall), but I tried doing mysqld start using --skip-grant-tables after successfully stopping the server, all to no avail:

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld start --skip-grant-tables --console
2023-02-27T17:39:07.449060Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.32) starting as process 12996
2023-02-27T17:39:07.454970Z 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
2023-02-27T17:39:07.455214Z 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
mysqld: File '.\binlog.index' not found (OS errno 13 - Permission denied)
2023-02-27T17:39:07.464183Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-02-27T17:39:07.465203Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.