'GRANT' ¸í·ÉÀ» ÀÌ¿ëÇÏ¸é ½±°Ô »ç¿ëÀÚ Ãß°¡ ¹× ±ÇÇÑ ¼³Á¤ÀÌ °¡´ÉÇÕ´Ï´Ù. (MySQL Manual 4.3.5)
ÀÏ¹Ý »ç¿ëÀÚ Ãß°¡
mysql> grant all privileges on dbuser.* to dbuser@localhost identified by 'password' with grant option;
ƯÁ¤ À̸§ÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ¸ðµç ±ÇÇÑÀ» °¡Áö´Â »ç¿ëÀÚ Ãß°¡
mysql> grant all privileges on `dbuser_%`.* to dbuser@localhost identified by 'password' with grant option;
'dbuser_'À¸·Î ½ÃÀ۵Ǵ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ¸ðµç ±ÇÇÑÀ» °¡Áö´Â 'dbuser' »ç¿ëÀÚ °èÁ¤ Ãß°¡%%% ÀÌ·±½ÄÀ¸·Î °èÁ¤À» ¸¸µé¸é »õ·Î¿î »ç¿ëÀÚ¿¡ ´ëÇÑ °³º°ÀûÀÎ µ¥ÀÌÅͺ£À̽º ±ÇÇÑ ¼³Á¤À» »ý·«ÇÒ ¼ö ÀÖ½À´Ï´Ù. -- ÀÌÇöÁø
--------------------------------------------------------------------------------
»ç¿ëÀÚ¿¡°Ô Database »ç¿ë ±ÇÇÑÀ» ÁÖ±â
mysql> INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv)
-> VALUES('%', 'DB¸í', '»ç¿ëÀÚ', 'Y', 'Y', 'Y', 'Y','Y','Y');
¸ðµç ±ÇÇÑÀ» ÁØ´Ù¸é ¾Æ·¡¿Í °°Àº ¹æ¹ýÀ» Çϴ°ÍÀÌ ´õ¿í Æí¸®Èü´Ï´Ù.
mysql> GRANT ALL on DB¸í.* TO id@'localhost' ;
mysql> GRANT ALL on DB¸í.* TO id;
mysql> GRANT ALL on DB¸í.* TO id@'xxx.xxx.xxx.%';
ù¹ø° localhost?·ÎÄà ȣ½ºÆ® (DB°¡ ÀÚ±âÄÄÇ»ÅÍ¿¡ ±ò·Á Àִ°æ¿ì..¿¡¸¸ Á¢¼ÓÀ» Çã¿ëÇÏ°Ú´Ù´Â ¶æÀÔ´Ï´Ù.
µÎ¹ø° ¹®ÀåÀº ·ÎÄà ȣ½ºÆ®¸¦ Á¦¿ÜÇÏ°í´Â ¸ðµç ip¿¡¼ Á¢±ÙÀ» ½ÃÅ°°Ú´Ù´Â ³»¿ëÀÔ´Ï´Ù.
¼¼¹ø°´Â cŬ·¡½º¸¸ Çã¿ëÇÏ°Ú´Ù´Â ÀÇ¹Ì ÀÔ´Ï´Ù. xxx.xxx.%.% ¸é BŬ·¡½º xxx.%.%.%¸é AŬ·¡½º·Î Á¦ÇÑÀ» ÇÒ¼ö ÀÖ½À´Ï´Ù.
±×¸®°í º¯°æµÈ ³»¿ëÀ» ¸Þ¸ð¸®¿¡ ¹Ý¿µÇϱâ À§ÇØ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇÕ´Ï´Ù.
mysql> FLUSH PRIVILEGES;
ÀÌ·¸°Ô MySQLÀ» ¼³Á¤ÇØ ³õÀ¸¸é »ç¿ëÀÚ°¡ ´Ù¸¥ È£½ºÆ®¿¡¼µµ Á¢¼ÓÇÒ ¼ö ÀÖ°í Å×À̺í Ãß°¡ »èÁ¦ µîµµ ÇÒ ¼ö ÀÖ½À´Ï´Ù.
--------------------------------------------------------------------------------
ÀÌ·¸°Ô ¼öµ¿À¸·Îµµ °¡´É ÇÏÁö¸¸ ¿äÁòÀº ÅøÀ» ¸¹ÀÌ »ç¿ëÇÕ´Ï´Ù. ÅøÀº DB¿¡ ´ëÇÑ ±âº»ÀûÀÎ Áö½Ä¸¸ ÀÖÀ¸¸é ¹«¸®°¡ ¾øÀÌ »ç¿ë µÇ´Â ³à¼®ÀÌÁÒ ^^%%% Àú°°ÀÌ Äõ¸®¿¡ ¾àÇÑ »ç¶÷µé¿¡°Ô´Â Á¤¸» À¯¸® ÇÕ´Ï´Ù. ¾Æ·¡ ÆäÀÌÁö¿¡ °¡¼Å¼ ´Ù¿î·Îµå¸¦ ¹ÞÀ¸¼¼¿ä :) ÇÑ±Û »ç¿ë¿¡ ¾à°£ÀÇ Á¦¾àÀÌ ÀÖ½À´Ï´Ù.%%% ´Ù¸¥ ¿©·¯°¡Áö DB°ü¸® ÅøÀÌ ÀÖÁö¸¸ »ó´çÈ÷ °í°¡ÀÇ ÅøÀ̶ø´Ï´Ù :) ¾ÏÈæÀÇ ·çÆ®¿¡¼ µ¹°í ÀÖ´Â ³à¼®µéÀÌ Á¾Á¾ ÀÖ½À´Ï´Ù.
http://www.mysql.com/downloads/mysqlcc.html
|