MySQL Forums
Forum List  »  General

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

Please post results as text here, not as images on other sites.

If root no longer has required privileges, you'll need to temporarily set the server to bypass authentication so you can modify root's privileges ... follow the sequence described under "reset root passwprd" at https://www.artfulsoftware.com/infotree/mysqltips.php, but instead of changing root's password, run the suggested query ...

select host,authentication_string,plugin from mysql.user
where user='root';

... and issue required grants to root eg ...

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION

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.