Lets check our current policy rules

SHOW VARIABLES LIKE 'validate_password%';

This is how we can change this values…

SET GLOBAL validate_password_length = 7;
SET GLOBAL validate_password_number_count = 0;
SET GLOBAL validate_password_mixed_case_count = 0;
SET GLOBAL validate_password_special_char_count = 0;