Re: 'root' is denied access to all databases/connections
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.
Subject
Written By
Posted
February 25, 2023 10:34PM
Re: 'root' is denied access to all databases/connections
February 27, 2023 11:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.