how to give user rights to database in mysql Your password does not satisfy the current policy requirements code example

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

mysql> SET GLOBAL validate_password.policy = 0;

Example 2: Your password does not satisfy the current policy requirements

SHOW VARIABLES LIKE 'validate_password%';