BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡

±Û¾´ÀÌ: mysql mysql user add Á¶È¸¼ö: 7040


'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


°ü·Ã±Û : ¾øÀ½ ±Û¾´½Ã°£ : 2010/08/16 12:37 from 112.187.223.214

  Å×ÀÌºí ½ºÆäÀ̽º ¿©À¯¿ë·® üũ ¸ñ·Ïº¸±â »õ±Û ¾²±â Áö¿ì±â ÀÀ´ä±Û ¾²±â ±Û ¼öÁ¤ inbound_connect_timeout  ¿¡·¯  
BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡