phpmyadmin  #1819 - Your password does not satisfy the current policy requirements 오류 수정
MySQL - password 정책 낮춰서 단순한 패스워드 사용하기 .
[MySQL]패스워드 정책 확인, 변경하기

vi /etc/mysql/mysql.conf.d/mysqld.cnf
다음 라인 추가
실행하면 뒤에 _가 붙어서 추가로 나온다.. 결국 한번더 _ 를 사용한 변수를 지정해야한다.. 이유 미확인

plugin-load-add=validate_password.so
validate_password.check_user_name=OFF
validate_password.dictionary_file=
validate_password.length=0
validate_password.mixed_case_count=0
validate_password.number_count=0
validate_password.policy=LOW
validate_password.special_char_count=0



validate_password_check_user_name=OFF
validate_password_dictionary_file=
validate_password_length=0
validate_password_mixed_case_count=0
validate_password_number_count=0
validate_password_policy=LOW
validate_password_special_char_count=0


체크사항
validate_password.policy=LOW
대신에  다음문장일수 있음.. 아직 미확인.
validate_password_policy=LOW

저장후 mysql 재가동
service mysql restart

확인방법
mysql -p -u root
SHOW VARIABLES LIKE 'validate_password%';


| validate_password.check_user_name    | ON    |
| 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    |



임시로 변경하려면 mysql 명령에서 실행
SET GLOBAL validate_password.policy=LOW;


설정 예)
# vi /etc/mysql/mysql.conf.d/mysqld.cnf

plugin-load-add=validate_password.so
validate_password.check_user_name=OFF
validate_password.dictionary_file=
validate_password.length=0
validate_password.mixed_case_count=0
validate_password.number_count=0
validate_password.policy=LOW
validate_password.special_char_count=0

validate_password_check_user_name=OFF
validate_password_dictionary_file=
validate_password_length=0
validate_password_mixed_case_count=0
validate_password_number_count=0
validate_password_policy=LOW
validate_password_special_char_count=0

default-time-zone="+09:00"

# service mysql restart