Re: Access denied for user 'root'@'localhost' (using password: YES)

[Karen Goh]

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.