error message:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
Reason:
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html#sysvar_validate_password.policy
How to Solve”
mysql> set global validate_password.policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password.length=8;
Query OK, 0 rows affected (0.00 sec)