how to change mysql password policy requirements [caching_sha2_password] to native code example

Example: Your password does not satisfy the current policy requirements

SHOW VARIABLES LIKE 'validate_password%';