MySQL 8 validate_password 정책

MySQL 8 validate_password

MySQL 8은 옵션명이 _ → . 로 바뀜 (validate_password_policy → validate_password.policy).

SHOW VARIABLES LIKE 'validate_password.%';

개발 환경에서 완화 예 (/etc/my.cnf 또는 /etc/mysql/mysql.conf.d/mysqld.cnf):

[mysqld]
validate_password.policy=LOW
default_password_lifetime=0
# 더 완화하려면
validate_password.length=6
validate_password.special_char_count=0
validate_password.mixed_case_count=0
validate_password.number_count=0

재시작 후 적용.