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

[Peter Brawley]

Quote

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

That cmd starts the server skipping grant tables and setting your datadir

If it doesn't hang, not, the server errored out. In that case run it again, adding --console to the commandline so that errors will appear right in front of you rather than being logged to the mysql error file.

If it hangs, the server is running. Now tou can start another commandline window, cd to C:\Program Files\MySQL\MySQL Server 8.0\bin, and start the mysql commandline client (named mysql) without authentication arguments (which is the point).

Quote

:\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.

What persuaded you that the Microsoft commandline prompt could process mysql client program commands directly? Follow the cmds as described above and in the cited article.