mysql unauthenticated user login 문제

unauthenticated user login 문제 해결법

mysql> show processlist;

+----+----------------------+----------------------+-------+---------+------+------------------+------------------+

| Id | User | Host | db | Command | Time | State | Info |

+----+----------------------+----------------------+-------+---------+------+------------------+------------------+

| 4 | unauthenticated user | 218.145.71.224:50060 | NULL | Connect | NULL | Reading from net | NULL |

| 5 | unauthenticated user | 218.145.71.224:50061 | NULL | Connect | NULL | login | NULL |

| 6 | unauthenticated user | 218.145.71.173:36167 | NULL | Connect | NULL | login | NULL |

| 7 | unauthenticated user | 222.122.197.28:50476 | NULL | Connect | NULL | login | NULL |

| 8 | unauthenticated user | 220.95.232.180:39991 | NULL | Connect | NULL | login | NULL |

| 10 | unauthenticated user | 222.122.197.28:50477 | NULL | Connect | NULL | login | NULL |

| 11 | unauthenticated user | 220.95.232.180:40300 | NULL | Connect | NULL | login | NULL

User 내용이 위처럼 unauthenticated user 이렇게 나올경우 원격 mysql접속이 안되는 문제가 발생한다.


이럴경우 my.cnf파일에 내용을 추가해 준다

skip-name-resolve

client 에서 server로 접속시에 DNS Lookup 과정을 생략해 줍니다.

localhost 로 접속하는 경우는 문제가 없지만 IP 로 접속하는 환경에서는

DNS 서버가 느리거나 아님 장애 발생시에 해당 옵션을 설정해 주므로써 DB

접속시에 문제점을 해결하실 수 있습니다

오래전 네이버 블로그에 작성했던 글을 티스토리로 옮김