[¼Ò¼ø¿ø]´ÔÀÌ ³²±â½Å ±Û:
>-----------------------------------------
>´äº¯ÀÚ°¡ ±âº»ÀûÀ¸·Î Âü°íÇÒ ³»¿ëÀÔ´Ï´Ù.
>- ¹èÆ÷ÆÇ(¿É¼Ç) :
>- Ä¿³Î¹öÀü(¿É¼Ç) :
>- µ¥¸ó¹öÀü(¿¹: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 '¾ÏÈ£';
ÀÌ·±½ÄÀ¸·Î µî·Ï ¶Ç´Â ¼öÁ¤ÇØ¾ß ÇÕ´Ï´Ù.
|