¿ù°£ Àα⠰Խù°

°Ô½Ã¹° 138°Ç
   
[MYSQL] unauthenticated user
±Û¾´ÀÌ : ÃÖ°í°ü¸®ÀÚ ³¯Â¥ : 2013-08-01 (¸ñ) 12:29 Á¶È¸ : 7014
±ÛÁÖ¼Ò :
                          



À¥°ú DB ¼­¹ö°¡ ºÐ¸®µÇ¾îÀִ ȯ°æÀÌ¿´À¸¸ç ÇÁ·Î¼¼¼­¸®½ºÆ®¿¡ ¾Æ·¡¿Í °°ÀÌ ¼öõ°³ÀÇ ¸Þ¼¼Áö°¡ ½×¿©ÀÖÀ½...
mysql> show processlist ;
| Id | User | Host | db | Command | Time | State | Info |
+--------+----------------------+----------------------+------+---------+------+-------+------------------+
...................
...................
| 100 | unauthenticated user | 211.xxx.xxx.xxx:55057 | | Connect | | login | |
| 101 | unauthenticated user | 211.xxx.xxx.xxx:55058 | | Connect | | login | |
| 102 | unauthenticated user | 211.xxx.xxx.xxx:55059 | | Connect | | login | |
| 103 | unauthenticated user | 211.xxx.xxx.xxx:55060 | | Connect | | login | |
| 104 | unauthenticated user | 211.xxx.xxx.xxx:55061 | | Connect | | login | |
| 105 | unauthenticated user | 211.xxx.xxx.xxx:55062 | | Connect | | login | |
| 106 | unauthenticated user | 211.xxx.xxx.xxx:55063 | | Connect | | login | |
| 107 | unauthenticated user | 211.xxx.xxx.xxx:36662 | | Connect | | login | |
| 108 | unauthenticated user | 211.xxx.xxx.xxx:36663 | | Connect | | login | |
| 109 | unauthenticated user | 211.xxx.xxx.xxx:55064 | | Connect | | login | |
| 110 | unauthenticated user | 211.xxx.xxx.xxx:55065 | | Connect | | login | |
| 111 | unauthenticated user | 211.xxx.xxx.xxx:36664 | | Connect | | login | |
...................
...................

¿øÀÎ : 
mysql ¼­¹öÀÇ °æ¿ì ipÁּҷΠŬ¶óÀ̾ðÆ® Á¢¼ÓÀÌ µé¾î¿À°Ô µÇ¸é ÇØ´ç ip¿¡ ´ëÇÑ resolvingÀ» ¼öÇàÇÏ°Ô µÈ´Ù. Áï, Á¢¼ÓÇÑ ³×°¡ ´©±¸³Ä? ¶ó°í ¹¯°ÔµÇ´Â °Çµ¥ ¹®Á¦´Â ÀÌ ÁúÀÇ¿¡ ´ëÇØ Á¤»óÀûÀ¸·Î ´ë´äÀ» ÇÏ°Ô µÇ¸é show processlist »ó¿¡ ip ºÎºÐÀÌ À̸§À¸·Î ³ª¿À°Ô µÇÁö¸¸ ³×Æ®¿öÅ© ȯ°æÀÌ ´À·Á dns serverÀÇ ´ë´äÀÌ ´Ê¾îÁö°Ô µÈ´Ù¸é ±×¸¸Å­ connectionÀ» À¯ÁöÇÏ°í ÀÖ´Â ¹®Á¦°¡ ¹ß»ýÇÏ°Ô µÈ´Ù.

Á¶Ä¡ : 
/etc/mysql/my.cnf  ÆÄÀÏ¿¡ ¾Æ·¡ ¿É¼Ç Ãß°¡

[mysqld]
...
skip-name-resolve
skip-host-cache

µ¥¸ó Àç½ÃÀÛ

À̸§ Æнº¿öµå
ºñ¹Ð±Û (üũÇÏ¸é ±Û¾´À̸¸ ³»¿ëÀ» È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.)
¿ÞÂÊÀÇ ±ÛÀÚ¸¦ ÀÔ·ÂÇϼ¼¿ä.
   

 



 
»çÀÌÆ®¸í : ¸ðÁö¸®³× | ´ëÇ¥ : ÀÌ°æÇö | °³ÀÎÄ¿¹Â´ÏƼ : ·©Å°´åÄÄ ¿î¿µÃ¼Á¦(OS) | °æ±âµµ ¼º³²½Ã ºÐ´ç±¸ | ÀüÀÚ¿ìÆí : mojily°ñ¹ðÀÌchonnom.com Copyright ¨Ï www.chonnom.com www.kyunghyun.net www.mojily.net. All rights reserved.