|
Unblock with 'mysqladmin flush-hosts' ¿¡·¯°¡ ³¯¶§
2010.05.30 08:01
±Û¾´ÀÌ : ¿î¿µÀÚ
Á¶È¸ : 224
̵̧ : 0
Host 'hostname' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'
[ ¿øÀÎ ]
ÇØ´ç¿À·ù´Â È£½ºÆ®·ÎºÎÅÍÀÇ Á¢¼Ó¿äûÁß max_connect_errors¿Í °ü·ÃµÈ Á¢¼ÓÀÇ ¼³Á¤°ªº¸´Ù ÃÊ°úÇÏ¿© ¹ß»ýÇÒ ¶§ »ý±â´Â ¿À·ùÀÌ´Ù. ¼³Á¤°ª ÀÌ»óÀÇ ¿äûÀÌ µé¾î¿Ã °æ¿ì mysqld´Â ÇØÅ· ¹× À߸øµÈ ¿äûÀ¸·Î °üÁÖÇÏ¿© host ºÎÅÍÀÇ Á¢¼ÓÀ» ºí¶ôÇÏ °ÔµÈ´Ù.
[ ÇØ°á ]
1.flush-hosts ¸í·É¾î¸¦ »ç¿ëÇÏ¿© ÃʱâÈÇÑ´Ù. [root@soma]# /usr/local/mysql/bin/mysqladmin -u root -p flush-hosts
2.mysql µ¥¸ó½ÃÀ۽à max_connect_errors °ªÀ» ¿Ã·ÁÁØ´Ù. [root@soma mysql]# ./bin/safe_mysqld --user=mysql -O max_connect_errors=10000 &
|
ÀλýÀº ª½À´Ï´Ù.
±×·¯¹Ç·Î ´Ù¸¥ »ç¶÷ÀÌ ¿ä±¸ÇÏ´Â »îÀ» »ì¸é¼ ½Ã°£À» ³¶ºñÇؼ´Â ¾È µË´Ï´Ù.
µ·°ú ¸í¿¹¸¦ ¾òÁö ¸øÇÏ´õ¶óµµ ³¡±îÁö ÀÚ½ÅÀÇ ±æÀ» °íÁýÇϽʽÿÀ |
|
|