mysql 프로세스에서 unauthenticated user 확인시
페이지 정보
작성자 HARULIFE 작성일 20-11-24 11:57 조회 35,914 댓글 0본문
| 165948 | unauthenticated user | xxx.xxx.xxx.xxx:60641 | | Connect | | login | |
| 165950 | unauthenticated user | xxx.xxx.xxx.xxx:60644 | | Connect | | login | |
| 165949 | unauthenticated user | xxx.xxx.xxx.xxx:60643 | | Connect | | login | |
| 165951 | unauthenticated user | xxx.xxx.xxx.xxx:60645 | | Connect | | login | |
| 165952 | unauthenticated user | xxx.xxx.xxx.xxx:60647 | | Connect | | login | |
| 165953 | unauthenticated user | xxx.xxx.xxx.xxx:60648 | | Connect | | login | |
| 165954 | unauthenticated user | xxx.xxx.xxx.xxx:60649 | | Connect | | login | |
| 165955 | unauthenticated user | xxx.xxx.xxx.xxx:60650 | | Connect | | login | |
| 165956 | unauthenticated user | xxx.xxx.xxx.xxx:60651 | | Connect | | login | |
| 165957 | unauthenticated user | xxx.xxx.xxx.xxx:60653 | | Connect | | login | |
| 165958 | unauthenticated user | xxx.xxx.xxx.xxx:60654 | | Connect | | login | |
.
.
.
| 165959 | unauthenticated user | xxx.xxx.xxx.xxx:60655 | | Connect | | login | |
| 166098 | unauthenticated user | xxx.xxx.xxx.xxx:60795 | | Connect | | login | |
| 166099 | unauthenticated user | xxx.xxx.xxx.xxx:60796 | | Connect | | login | |
| 166100 | unauthenticated user | xxx.xxx.xxx.xxx:60797 | | Connect | | login | |
| 166101 | unauthenticated user | xxx.xxx.xxx.xxx:60798 | | Connect | | login | |
| 166102 | unauthenticated user | xxx.xxx.xxx.xxx:60799 | | Connect | | login | |
| 166103 | unauthenticated user | xxx.xxx.xxx.xxx:60800 | | Connect | | login | |
| 166104 | unauthenticated user | xxx.xxx.xxx.xxx:60801 | | Connect | | login | |
| 166105 | unauthenticated user | xxx.xxx.xxx.xxx:60802 | | Connect | | login | |
+--------+----------------------+-----------------------+--------+---------+------+-------+------------------+
위와같은 프로세스가 확인될시엔 my.cnf 설정부분에서 skip-name-resolve 해당구문을 추가해주면된다.
| 165950 | unauthenticated user | xxx.xxx.xxx.xxx:60644 | | Connect | | login | |
| 165949 | unauthenticated user | xxx.xxx.xxx.xxx:60643 | | Connect | | login | |
| 165951 | unauthenticated user | xxx.xxx.xxx.xxx:60645 | | Connect | | login | |
| 165952 | unauthenticated user | xxx.xxx.xxx.xxx:60647 | | Connect | | login | |
| 165953 | unauthenticated user | xxx.xxx.xxx.xxx:60648 | | Connect | | login | |
| 165954 | unauthenticated user | xxx.xxx.xxx.xxx:60649 | | Connect | | login | |
| 165955 | unauthenticated user | xxx.xxx.xxx.xxx:60650 | | Connect | | login | |
| 165956 | unauthenticated user | xxx.xxx.xxx.xxx:60651 | | Connect | | login | |
| 165957 | unauthenticated user | xxx.xxx.xxx.xxx:60653 | | Connect | | login | |
| 165958 | unauthenticated user | xxx.xxx.xxx.xxx:60654 | | Connect | | login | |
.
.
.
| 165959 | unauthenticated user | xxx.xxx.xxx.xxx:60655 | | Connect | | login | |
| 166098 | unauthenticated user | xxx.xxx.xxx.xxx:60795 | | Connect | | login | |
| 166099 | unauthenticated user | xxx.xxx.xxx.xxx:60796 | | Connect | | login | |
| 166100 | unauthenticated user | xxx.xxx.xxx.xxx:60797 | | Connect | | login | |
| 166101 | unauthenticated user | xxx.xxx.xxx.xxx:60798 | | Connect | | login | |
| 166102 | unauthenticated user | xxx.xxx.xxx.xxx:60799 | | Connect | | login | |
| 166103 | unauthenticated user | xxx.xxx.xxx.xxx:60800 | | Connect | | login | |
| 166104 | unauthenticated user | xxx.xxx.xxx.xxx:60801 | | Connect | | login | |
| 166105 | unauthenticated user | xxx.xxx.xxx.xxx:60802 | | Connect | | login | |
+--------+----------------------+-----------------------+--------+---------+------+-------+------------------+
위와같은 프로세스가 확인될시엔 my.cnf 설정부분에서 skip-name-resolve 해당구문을 추가해주면된다.
댓글목록 0
등록된 댓글이 없습니다.