MySQL Forums
Forum List  »  Install & Repo

Re: Unable to reset root password
Posted by: Peter Brawley
Date: November 19, 2021 11:49AM

> Query OK, 0 rows affected. Rows matched 4, Changed: 0, and Warnings 0.

That tells you it did not find a row where user='root', which in turn suggests the row has been edited or deleted. Try again with --skip-grat-tables, this time execute ...

select host, user, authentication_string
from mysql.user;

... and post the result here.

Options: ReplyQuote


Subject
Written By
Posted
November 19, 2021 11:09AM
Re: Unable to reset root password
November 19, 2021 11:49AM


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.