MySQL Forums
Forum List  »  General

Re: Access denied for user 'root'@'localhost' (using password: YES)
Posted by: Peter Brawley
Date: June 08, 2021 07:06AM

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.

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.