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