[리눅스] mysql패스워드 정책 확인, 변경하기

mysql 패스워드 정책 확인, 변경하기

CREATE USER 'zabbix'@'%' IDENTIFIED BY 'ahslxjf11wcd1!';

mysql> CREATE USER 'zabbix'@'%' IDENTIFIED BY 'ahslxjf11wcd1!';
[에러] ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

비밀번호 유효성 검사 플러그인 시스템 변수 확인(MEDIUM)

SHOW VARIABLES LIKE 'validate_password%';

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)

비밀번호 유효성 검사 플러그인 시스템 변수 변경

SET GLOBAL validate_password_policy=LOW;

비밀번호 유효성 검사 플러그인 시스템 변수 확인(LOW)

SHOW VARIABLES LIKE 'validate_password%';

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             | LOW   |
| validate_password_special_char_count | 1     |
+--------------------------------------+-------+
7 rows in set (0.01 sec)

패스워드 변경

CREATE USER 'zabbix'@'%' IDENTIFIED BY 'ahslxjf11wcd1!';

mysql> CREATE USER 'zabbix'@'%' IDENTIFIED BY 'ahslxjf11wcd1!';
Query OK, 0 rows affected (0.00 sec)

---

my.cnf validate_opassword_policy에서 LOW로 수정

vim /etc/my.cnf

[client]
default-character-set=utf8

[mysqld]
character-set-server=utf8

##password Policy
validate_password_policy=LOW
validate_password_length=4

 

참고URL

- MySQL 패스워드 정책 확인, 변경하기 : https://scbyun.com/710

- dev.mysql.com : https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html