MariaDB 비밀번호 보안 정책

확인

SHOW VARIABLES LIKE '%password%';
SHOW PLUGINS;
SHOW COMPONENTS;

플러그인/컴포넌트

-- MySQL 5+: 플러그인
INSTALL PLUGIN validate_password SONAME 'validate_password.so';
UNINSTALL PLUGIN validate_password;

-- MySQL 8+: 컴포넌트
INSTALL COMPONENT 'file://component_validate_password';
UNINSTALL COMPONENT 'file://component_validate_password';

정책 (임시 완화)

SET GLOBAL validate_password_policy = 0;
SHOW VARIABLES LIKE 'validate_password%';