Centos7-mysql執行報錯ERROR1820(HY000):YoumustresetyourpasswordusingALTERUSERstatementbeforeexecutingthisstatement.

剛安裝的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!