MySQL Your password does not satisfy the current policy requirements
When i try to create MySQL user on a server, i get following error
1 2 3 |
mysql> GRANT ALL PRIVILEGES ON *.* TO 'centovacast'@'localhost' IDENTIFIED BY '*5B5F6EB22D64C7D8FE384BEF890B55964482A144' WITH GRANT OPTION; ERROR 1819 (HY000): Your password does not satisfy the current policy requirements mysql> |
This is due to MySQL validate password settings
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
mysql> SHOW VARIABLES LIKE 'validate_password%'; +--------------------------------------+--------+ | Variable_name | Value | +--------------------------------------+--------+ | validate_password_check_user_name | OFF | | validate_password_dictionary_file | | | validate_password_length | 8 | | validate_password_mixed_case_count | 1 | | validate_password_number_count | 1 | | validate_password_policy | MEDIUM | | validate_password_special_char_count | 1 | +--------------------------------------+--------+ 7 rows in set (0.01 sec) mysql> |
To fix the error for current session, run
1 |
SET GLOBAL validate_password_mixed_case_count = 0; |
Now password change will work.
1 2 3 4 5 6 7 |
mysql> SET GLOBAL validate_password_mixed_case_count = 0; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON *.* TO 'centovacast'@'localhost' IDENTIFIED BY '*5B5F6EB22D64C7D8FE384BEF890B55964482A144' WITH GRANT OPTION; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> |
If you need it made permanent, then edit MySQL configuration file and add the line under [mysqld] section.
1 |
validate_password_mixed_case_count = 0 |
See MySQL