Centos7-mysql運作報錯ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

剛安裝的mysql，輸入任何内容都報

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

就是要重新設定一下密碼的意思

SET PASSWORD = PASSWORD('yourpwd');
           

繼續報錯：ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

密碼太簡單了。？？？ 還簡單？ 幹脆修改密碼政策。

set global validate_password_policy=0;
set global validate_password_length=1;           

SET PASSWORD = PASSWORD('yourpwd');
           

ok!