MySQL Forums
Forum List  »  General

Re: Access denied for user 'root'@'localhost' (using password: YES)
Posted by: Karen Goh
Date: June 07, 2021 10:06PM

Hi Peter,

I am not getting you in fixing this root being denied error.
So, now I stopped the mysql service by :


C:\>net stop MySQL80
The MySQL80 service is not started.

and then I started another cmd and did the following:

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --skip-grant-tables --datadir="C:\ProgramData\MySQL\MySQL Server 8.0\Data"

C:\Program Files\MySQL\MySQL Server 8.0\bin>select host,authentication_string,plugin from mysql.user
'select' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\MySQL\MySQL Server 8.0\bin>where user='root';
INFO: Could not find files for the given pattern(s).

C:\Program Files\MySQL\MySQL Server 8.0\bin>select user();
'select' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld select user();
2021-06-07T16:03:03.146375Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.23) starting as process 1864
2021-06-07T16:03:03.149702Z 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-06-07T16:03:03.149878Z 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-06-07T16:03:03.150086Z 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-06-07T16:03:03.152091Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-06-07T16:03:03.152303Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.23) MySQL Community Server - GPL.

Really, I am lost what the above error message all about and what is happening now.

Hope you could guide me further in resolving this root being denied.

Thanks for your help in advance.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.