티스토리 뷰

___리눅스

[MySQL] MySQL 패스워드 정책 확인, 변경하기

변군 변군이글루 2020. 6. 22. 16:01

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

 

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

[에러] ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

 

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> SET GLOBAL validate_password_policy=LOW;

 

mysql> 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)

 

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

 

댓글
댓글쓰기 폼