MySQL Forums
Forum List  »  Newbie

Question ABOUT change my root password for MySQL 8.0.23
Posted by: five small
Date: February 07, 2021 12:44AM

yesterday , I want to change my root password,and use follow code:

update user set authentication_string=MD5("123") where user ="root";

But after that ,I can't use 'mysql -u root -p123' to login mysql server any more.

Please Help me , Thanks A lot.

Options: ReplyQuote


Subject
Written By
Posted
Question ABOUT change my root password for MySQL 8.0.23
February 07, 2021 12:44AM


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.