[»êÀÌ]´ÔÀÌ ³²±â½Å ±Û:
>[¼Ò¼ø¿ø]´ÔÀÌ ³²±â½Å ±Û:
>
>>-----------------------------------------
>>´äº¯ÀÚ°¡ ±âº»ÀûÀ¸·Î Âü°íÇÒ ³»¿ëÀÔ´Ï´Ù.
>>- ¹èÆ÷ÆÇ(¿É¼Ç) :
>>- Ä¿³Î¹öÀü(¿É¼Ç) :
>>- µ¥¸ó¹öÀü(¿¹:apache 1.3.27) :
>>- µ¥¸ó¼³Ä¡À¯Çü(RPM/ÄÄÆÄÀÏ/±âŸ)
:
>>-----------------------------------------
>>Áõº¸ÆÇ 1079ÂÊ
>>
>>µÎ ¹ø° ¹®´Ü
>>MySQLŬ¶óÀ̾ðÆ® È£½ºÆ® À̸§À̳ª IP ÁÖ¼Ò°¡ °¢°¡ ¸ðµÎ µî·ÏµÇ¾î ÀÖ¾î¾ß
ÇÑ´Ù.
>>
>>
>>¾î¶»°Ô µî·ÏÇϳª¿ä?
>>±¸Ã¼Àû ¹æ¹ýÀ» ¾Ë·ÁÁÖ¼¼¿ä
>>
>>
>>°¨»çÇÕ´Ï´Ù.
>
>========================================
>
>mysql.user Å×À̺í°ú mysql.db Å×À̺íÀÇ Host Ä÷³¿¡ µî·Ï(ÀÔ·Â)µÇ¾î¾ß
>ÇÔÀ» ÀǹÌÇÕ´Ï´Ù.
>
>Áï »ç¿ëÀÚ µî·Ï½Ã È£½ºÆ®(Host) Ä÷³¿¡ Çã¿ëÇÒ È£½ºÆ®¸¦ µî·ÏÇ϶ó´Â
>ÀǹÌÀÔ´Ï´Ù.
>
>¿¹¸¦µé¾î,
>
>mysql> INSERT INTO mysql.user (user,host,password)
> VALUES ('À¯Àú','µî·ÏÇÒÈ£½ºÆ®',PASSWORD('¾ÏÈ£'));
>mysql> INSERT INTO mysql.db
> VALUES ('µî·ÏÇÒÈ£½ºÆ®','DBÀ̸§','À¯Àú','Y','Y',....);
>
>or
>
>mysql> UPDATE mysql.user SET host = 'µî·ÏÇÒÈ£½ºÆ®'
> WHERE user = 'À¯Àú';
>mysql> UPDATE mysql.db SET host = 'µî·ÏÇÒÈ£½ºÆ®'
> WHERE user = 'À¯Àú';
>
>or
>
>mysql> GRANT ALL PRIVILEGES
> ON 'DBÀ̸§'.*
> TO 'À¯Àú'@'µî·ÏÇÒÈ£½ºÆ®'
> IDENTIFIED BY PASSWORD '¾ÏÈ£';
>
>ÀÌ·±½ÄÀ¸·Î µî·Ï ¶Ç´Â ¼öÁ¤ÇØ¾ß ÇÕ´Ï´Ù.
========================================
|