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

New Topic

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

Posted by: Peter Brawley
Date: June 01, 2021 10:46PM

Yikes. Stop the server. Then in a cmd client run ...

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

If that errors out, fix the error and try again. When it succeeds, the server is running, so it hangs.

Now in a second cmd window run mysql without authentication arguments (which is the whole point, remember?).

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

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

Karen Goh

May 26, 2021 04:16AM

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

Peter Brawley

May 26, 2021 12:10PM

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

Karen Goh

May 27, 2021 07:43AM

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

Peter Brawley

May 27, 2021 10:53AM

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

Karen Goh

May 27, 2021 06:06PM

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

Peter Brawley

May 27, 2021 08:07PM

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

Karen Goh

June 01, 2021 10:06PM

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

Peter Brawley

June 01, 2021 10:46PM

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

Karen Goh

June 07, 2021 10:06PM

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

Peter Brawley

June 08, 2021 07:06AM

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.