當建立 MySQL 帳號或者修改密碼時, 密碼強度不符合要求, 會出現以下錯誤
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements.
查看密碼強度規則
show variables like 'validate_pass%';+--------------------------------------+--------+
| 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 |
+--------------------------------------+--------+修改密碼強度為最低
set global validate_password_policy=0;修改密碼長度為4 (最短)
set global validate_password_length=4;修改密碼 特殊符號為最低
set global validate_password_special_char_count:0; 再次查看規則
show variables like 'validate_pass%';+--------------------------------------+-------+
| Variable_name | Value |
+--------------------------------------+-------+
| validate_password_check_user_name | OFF |
| validate_password_dictionary_file | |
| validate_password_length | 4 |
| validate_password_mixed_case_count | 1 |
| validate_password_number_count | 1 |
| validate_password_policy | LOW |
| validate_password_special_char_count | 0 |
+--------------------------------------+-------+修改 root 密碼
SET PASSWORD FOR 'root'@'localhost': PASSWORD('123456');
