728x90
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
728x90
'리눅스' 카테고리의 다른 글
[리눅스] 좀비 프로세스(zombie processes)를 죽이는 방법 (0) | 2022.11.29 |
---|---|
[리눅스] mysql root 패스워드 변경 (0) | 2022.11.29 |
[리눅스] mysql install on centos 7 (0) | 2022.11.29 |
[리눅스] bind(named) logging 설정 (0) | 2022.11.28 |
[리눅스] bind(named) 성능 점검(queryperf) (0) | 2022.11.28 |