@Amit Mishra Are you using MySQL 8.x? In MySQL 8.0.4, the validate_password plugin was re-implemented as the validate_password component. https://dev.mysql.com/doc/refman/8.0/en/validate-password.html So please try using the password something like "Bigdata@123456" It depends on what kind of policy is added to your MySQL: The policies implement increasingly strict password tests. The following descriptions refer to default parameter values, which can be modified by changing the appropriate system variables.
LOW policy tests password length only. Passwords must be at least 8 characters long. To change this length, modify validate_password.length . MEDIUM policy adds the conditions that passwords must contain at least 1 numeric character, 1 lowercase character, 1 uppercase character, and 1 special (nonalphanumeric) character. To change these values, modify validate_password.number_count , validate_password.mixed_case_count , and validate_password.special_char_count . STRONG policy adds the condition that password substrings of length 4 or longer must not match words in the dictionary file, if one has been specified. To specify the dictionary file, modify validate_password.dictionary_file . .
... View more
