MySQL Forums
Forum List  »  Newbie

Error 1820 and Error 1819
Posted by: Aditya Gopal
Date: October 25, 2016 01:50AM

Hi,

I just installed mysql and i couldn't access it. So i set skip-grant-tables in my.cnf to access the server and then set a password with
UPDATE user SET authentication_string = PASSWORD('qwerty') WHERE User = 'root';

After restart the server and logging in, I can't use any command. I get an error

>>ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

But trying (ALTER USER 'root'@'localhost' IDENTIFIED BY 'qwerty123';) gives me another error.

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

I'd really appreciate any help at all.
Thanks

Options: ReplyQuote


Subject
Written By
Posted
Error 1820 and Error 1819
October 25, 2016 01:50AM
October 25, 2016 10: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.