Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2002/08/05(15:22) from 210.117.182.162 | |
ÀÛ¼ºÀÚ : °ÁÙ±â (jkkang65@hanmail.net) | Á¶È¸¼ö : 4218 , ÁÙ¼ö : 236 |
Re: [MySQL] »õ·Î¿î »ç¿ëÀÚ µî·Ï ¹× ±ÇÇÑÁöÁ¤ |
---|
6.8 Ãʱâ mysql ±ÇÇѼ³Á¤ mysqlÀ» ¼³Ä¡ÇÏ°í ³ª¼, mysql_install_db ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇؼ Ãʱâ Á¢±Ù ±ÇÇÑÀ» ¼³ Á¤ÇØ¾ß ÇÑ´Ù. 4.7.1 [Quick install] Âü°í. mysql_install_db ½ºÅ©¸³Æ®´Â mysqld ¼¹ö ¸¦ ½ÃÀÛÇÏ°í, ´ÙÀ½°ú °°ÀÌ ½ÂÀÎ Å×À̺íÀÇ ±ÇÇÑÀ» ÃʱâÈÇÑ´Ù: - mysql root »ç¿ëÀÚ´Â ½´ÆÛÀ¯ÀúÀÌ¸ç ¸ðµç °ÍÀ» ÇÒ ¼ö ÀÖ´Ù. ·ÎÄà ȣ½ºÆ®¿¡¼¸¸ ¿¬°á ÇÒ ¼ö ÀÖ´Ù. ÁÖÀÇ : óÀ½¿¡ root ºñ¹Ð¹øÈ£´Â ºñ¾îÀÖ´Ù. ±×·¡¼ ´©±¸³ª ºñ¹Ð¹øÈ£¾øÀÌ root·Î ¿¬°á ÇÒ ¼öÀÖ°í ¸ðµç ±ÇÇÑÀ» ½ÂÀι޴´Ù. - ÀÍ¸í »ç¿ëÀÚ´Â 'test' ³ª 'test_' ·Î ½ÃÀÛÇÏ´Â µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ¸ðµç ±ÇÇÑÀ» ½Â Àι޴´Ù. ¸ðµç »ç¿ëÀÚ°¡ ·ÎÄà ȣ½ºÆ®¿¡¼ ¿¬°áÇÒ ¼ö ÀÖÀ¸¸ç ÀÍ¸í »ç¿ëÀÚ·Î °£ÁֵȴÙ. - ´Ù¸¥ ±ÇÇÑÀº °ÅºÎµÈ´Ù. ¿¹¸¦ µé¾î ÀÏ¹Ý »ç¿ëÀÚ´Â mysqladmin shutdown À̳ª mysqladmin processlist ¸¦ »ç¿ëÇÒ ¼ö ¾ø´Ù. ¼³Ä¡ÇßÀ» ¶§ Ãʱ⠱ÇÇÑÀÌ Æø³Ð°Ô ¼³Á¤µÇ¾î Àֱ⠶§¹®¿¡ °¡Àå ¸ÕÀú mysql root »ç¿ëÀÚ ÀÇ ºñ¹Ð¹øÈ£¸¦ ¼³Á¤ÇØ¾ß ÇÑ´Ù. ´ÙÀ½°ú °°ÀÌ ¼³Á¤ÇÏ¸é µÈ´Ù. (PASSWORD() ÇÔ¼ö¸¦ ÀÌ¿ë ÇØ ºñ¹Ð¹øÈ£¸¦ ¼³Á¤ÇØ¾ß ÇÑ´Ù!): shell> mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; mysql> FLUSH PRIVILEGES; or shell> mysqladmin -u root password new_password (** PASSWORD() ¶ó´Â ÇÔ¼ö¸¦ »ç¿ëÇÏÁö ¾Ê¾Æµµ µÇ¹Ç·Î Æí¸®ÇÔ. ¶ÇÇÑ SQL¹®¿¡¼ grant ¸í·ÉÀ» ÀÌ¿ëÇØ ¼³Á¤ÇÒ ¼öµµ ÀÖÁö¿ä **) ù¹ø° ¹æ¹ýÀ» »ç¿ëÇϸé Á÷Á¢ user Å×À̺íÀÇ ºñ¹Ð¹øÈ£¸¦ ¾÷µ¥ÀÌÆ®ÇÑ´Ù. ÀÌ °æ¿ì ¼¹ö °¡ ´Ù½Ã ½ÂÀÎ Å×À̺íÀ» Àеµ·Ï ÇØ¾ß ÇÑ´Ù.(FLUSH PRIVILEGES »ç¿ë). ¿Ö³ÄÇÏ¸é ´Ù¸¥ ¹æ ¹ýÀ¸·Î´Â º¯°æ»çÇ×À» ¾Ë¸± ¼ö ¾ø±â ¶§¹®ÀÌ´Ù. (** ½ÂÀÎ Å×À̺íÀ» ´Ù½Ã ÀÐÁö ¾Ê¾Æ¼ ÀÌÀü¿¡ ¼³Á¤Çß´ø ºñ¹Ð¹øÈ£°¡ Á¦´ë·Î ¾ÈµÇ´Â °æ¿ì °¡ ÀÖÀ» °ÍÀÔ´Ï´Ù. ²À ±â¾ïÇÏ°í ÀÖ¾î¾ßÇØ¿ä **) rootºñ¹Ð¹øÈ£°¡ ¼³Á¤µÇ¾úÀ¸¸é ¼¹ö¿¡ rootÁ¢¼ÓÇÒ¶§¸¶´Ù ºñ¹Ð¹øÈ£¸¦ ¸í½ÃÇØ¾ß ÇÑ´Ù. Ãß°¡·Î ¼Â¾÷À» Çϰųª Å×½ºÆ®ÇÒ ¶§´Â ºñ¹Ð¹øÈ£¸¦ ¼³Á¤ÇÒ ÇÊ¿ä°¡ ¾ø±â ¶§¹®¿¡ root ºñ ¹Ð¹øÈ£¸¦ ºó°ªÀ¸·Î ³²°ÜµÎ°í ½ÍÀ» °ÍÀÌ´Ù. ±×·¸Áö¸¸ ½ÇÁ¦ ÀÛ¾÷À» Çϱâ Àü¿¡´Â ¹Ýµå½Ã ºñ¹Ð¹øÈ£¸¦ ¼³Á¤Çß´ÂÁö È®ÀÎÇØ¾ß ÇÑ´Ù. ±âº»±ÇÇÑÀ» ¾î¶»°Ô ¼³Á¤ÇÏ´ÂÁö mysql_install_db ½ºÅ©¸³Æ®¸¦ »ìÆ캸ÀÚ. ´Ù¸¥ »ç¿ëÀÚ¿¡ °Ô ±ÇÇÑÀ» ¾î¶»°Ô ¼³Á¤ÇÒÁö ÀÌ°ÍÀ» ±âº»À¸·Î »ç¿ëÇÒ ¼ö ÀÖ´Ù. À§¿¡¼ ¼³¸íÇÑ °Í°ú ´Ù¸£°Ô Ãʱ⠱ÇÇÑÀ» ¼³Á¤Çϱ⠿øÇϸé, mysql_install_db ½ºÅ©¸³Æ® ¸¦ ½ÇÇàÇϱâ Àü¿¡ ¼öÁ¤ÇÏ¸é µÈ´Ù. ¿ÏÀüÇÏ°Ô ½ÂÀÎ Å×À̺íÀ» ´Ù½Ã ¸¸µé±â À§ÇØ mysql µ¥ÀÌÅͺ£À̽º¸¦ Æ÷ÇÔÇÏ´Â µð·ºÅ丮 ÀÇ '*ISM' °ú '*.ISD' ÆÄÀÏÀ» Á¦°ÅÇØ¾ß ÇÑ´Ù. (ÀÌ µð·ºÅ丮´Â database µð·ºÅ丮¿¡ ¼ 'mysq''À̶ó´Â À̸§ÀÌ ºÙ¾îÀÖ´Ù. mysqld --help Çؼ database µð·ºÅ丮ÀÇ ¸ñ·ÏÀ» º¼ ¼ö ÀÖ´Ù.) ¿øÇϴ´ë·Î ±ÇÇÑÀ» ¼öÁ¤ÇÑ ÈÄ mysql_install_db ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÏÀÚ. 6.9 mysql¿¡ »õ·Î¿î »ç¿ëÀÚ ±ÇÇÑ Ãß°¡Çϱ⠵ΰ¡Áö ¹æ¹ýÀ¸·Î »ç¿ëÀÚ¸¦ Ãß°¡ÇÒ ¼ö ÀÖ´Ù : GRANT ¹® »ç¿ë ¶Ç´Â mysql ½ÂÀÎ Å×À̺í Á÷Á¢ Á¶ÀÛ. GRANT ¹®À» »ç¿ëÇÏ´Â °ÍÀÌ ´õ ¼±È£µÇ´Â ¹æ¹ýÀÌ´Ù. ¾Æ·¡ÀÇ ¿¹Á¦´Â »õ·Î¿î »ç¿ëÀÚ¸¦ ¼³Á¤Çϱâ À§ÇØ ¾î¶»°Ô mysql Ŭ¶óÀ̾ðÆ®¸¦ »ç¿ëÇÏ´ÂÁö º¸¿©ÁØ´Ù. ÀÌ ¿¹Á¦´Â ÀÌÀü¿¡ ¼³¸íÇß´ø°Í°ú °°ÀÌ ±âº»°ª¿¡ µû¶ó ±ÇÇÑÀ» ¼³Á¤ÇÏ´Â °Í À¸·Î °¡Á¤ÇÑ´Ù. ÀÌ°ÍÀº ¼³Á¤À» ¹Ù²Ù±â À§ÇØ mysqld°¡ ½ÇÇàµÇ°í ÀÖ´Â °°Àº ½Ã½ºÅÛ¿¡ ÀÖ ¾î¾ß ÇÑ´Ù´Â °ÍÀ» ¸»ÇÑ´Ù. (**ÃʱⰪÀº localhost¿¡¼¸¸ Á¢¼Ó °¡´ÉÇϹǷÎ**) ¶ÇÇÑ mysql root »ç¿ëÀÚ·Î Á¢¼ÓÇØ¾ß ÇÏ°í root »ç¿ëÀÚ´Â mysql µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ insert ±ÇÇÑ°ú reload °ü¸®ÀÚ ±ÇÇÑÀÌ ÀÖ¾î¾ß ÇÑ´Ù. root »ç¿ëÀÚÀÇ ºñ¹Ð¹øÈ£¸¦ ¹Ù²Ù¾ú À¸¸é, ¾Æ·¡¿Í °°ÀÌ mysql ¸í·ÉÇà »óÅ¿¡¼ ºñ¹Ð¹øÈ£¸¦ ¸í½ÃÇØ¾ß ÇÑ´Ù. GRANT ¹®À» ÀÌ¿ëÇØ »õ·Î¿î »ç¿ëÀÚ¸¦ Ãß°¡ÇÒ ¼ö ÀÖ´Ù: shell> mysql --user=root mysql mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost IDENTIFIED BY 'password' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%" IDENTIFIED BY 'password' WITH GRANT OPTION; mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost; mysql> GRANT USAGE ON *.* TO dummy@localhost; À§ GRANT ¹®¿¡¼´Â ¼¼ ¸íÀÇ »ç¿ëÀÚ¸¦ ¼³Á¤ÇÑ´Ù: monty : ¾î´À °÷¿¡¼µç ¼¹ö¿¡ ¿¬°áÇÒ ¼ö ÀÖ´Â ¿ÏÀüÇÑ ½´ÆÛÀ¯ÀúÀÌÁö¸¸ ºñ¹Ð¹øÈ£¸¦ »ç ¿ëÇØ¾ß ÇÑ´Ù. ¿ì¸®´Â monty@localhost ¿Í monty@"%"¸¦ »ç¿ëÇÑ GRANT ¹®¿¡ ´ëÇؼ ¹Ýµå ½Ã ³íÀǸ¦ ÇØ¾ß ÇÑ´Ù. localhost ¸ñ·ÏÀ» Ãß°¡ÇÏÁö ¾ÊÀ¸¸é, mysql_install_db ¿¡ ÀÇÇØ »ý¼ºµÈ localhost ÀÇ ÀÍ¸í »ç¿ëÀÚ ¸ñ·Ï(µî·Ï?)ÀÌ ·ÎÄà ȣ½ºÆ®¿¡¼ Á¢¼ÓÇÒ¶§ ¿ì¼±±ÇÀ» °®´Â´Ù. ¿Ö³ÄÇϸé ÁöÁ¤µÈ Host ÇÊµå °ªÀÌ ÀÖÀ¸¸ç Á¤¿ ¼ø¼¿¡¼ ¸ÕÀú ¿À±â ¶§¹®ÀÌ´Ù. (** ½ÂÀÎ Å×À̺íÀÇ Á¤¿ ¼ø¼°¡ ƯÁ¤ÇÑ Host¸¦ ÁöÁ¤ÇÑ °ÍºÎÅÍ ½ÃÀÛÇÏ´Â °ÍÀ» ±â¾ïÇÏÀÚ. admin : ºñ¹Ð¹øÈ£ ¾øÀÌ localhost¿¡¼ Á¢¼ÓÇÒ ¼ö ÀÖÀ¸¸ç reload¿Í process °ü¸®ÀÚ ±Ç ÇÑÀ» ½ÂÀιÞÀº »ç¿ëÀÚ. ÀÌ°æ¿ì »ç¿ëÀÚ°¡ mysqladmin processlist »Ó¸¸ ¾Æ´Ï¶ó mysqladmin reload, mysqladmin refresh, mysqladmin flush-* ¸í·ÉÀ» ½ÇÇàÇÒ ¼ö ÀÖ´Ù. µ¥ÀÌÅͺ£À̽º¿Í °ü·ÃµÈ ±ÇÇÑÀº ½ÂÀεÇÁö ¾Ê¾Ò´Ù. ÀÌ°ÍÀº Ãß°¡ÀûÀÎ GRANT ¹®À» »ç¿ëÇØ ³ªÁß¿¡ ½ÂÀÎÇÒ ¼ö ÀÖ´Ù. dummy : ºñ¹Ð¹øÈ£¾øÀÌ ¿¬°áÇÒ ¼ö ÀÖÁö¸¸ ¿ÀÁ÷ localhost¿¡¼¸¸ ¿¬°á °¡´ÉÇÑ »ç¿ëÀÚ. ±ÇÇÑ À¯Çü(privilege type)ÀÌ USAGE À̱⠶§¹®¿¡ ÀüüÀûÀÎ ±ÇÇÑÀÌ 'N'·Î ¼³Á¤µÇ¾î ÀÖ ´Ù. USAGE ´Â ¾Æ¹«·± ±ÇÇѵµ ¼³Á¤ÇÏÁö ¾Ê´Â´Ù. ³ªÁß¿¡ µ¥ÀÌÅͺ£À̽º¿Í °ü·ÃµÈ ±ÇÇÑÀ» ½ÂÀÎÇÒ ¼ö ÀÖ´Ù. ¶ÇÇÑ µ¿ÀÏÇÑ »ç¿ëÀÚ Á¢±Ù Á¤º¸¸¦ INSERT ¹®À» ÅëÇØ Á÷Á¢ Ãß°¡ÇÒ ¼ö ÀÖÀ¸¸ç ÀÌ°æ¿ì¿¡´Â ¼¹ö°¡ ½ÂÀÎ Å×À̺íÀ» ´Ù½Ã Àеµ·Ï ¾Ë·ÁÁÖ¾î¾ß ÇÑ´Ù.(**FLUSH PRIVILEGES »ç¿ë**) shell> mysql --user=root mysql mysql> INSERT INTO user VALUES('localhost','monty',PASSWORD('something'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y') mysql> INSERT INTO user VALUES('%','monty',PASSWORD('something'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y') mysql> INSERT INTO user SET Host='localhost',User='admin', Reload_priv='Y', Process_priv='Y'; mysql> INSERT INTO user (Host,User,Password) VALUES('localhost','dummy',"); mysql> FLUSH PRIVILEGES; mysql ¹öÀü¿¡ µû¶ó À§¿¡¼ 'Y' °ªÀÌ ´Ù¸¦ ¼ö ÀÖ´Ù´Â °ÍÀ» ±â¾ïÇÏÀÚ. 3.22.11 ¹öÀü ÀÌ ÈÄ¿¡¼ »ç¿ëÇÒ ¼ö ÀÖ´Â È®ÀåµÈ INSERT ¹®Àº ¿©±â¼ admin »ç¿ëÀÚ¿¡°Ô »ç¿ëµÇ¾ú´Ù. ½´ÆÛÀ¯Àú¸¦ ¼³Á¤Çϱâ À§ÇØ ±ÇÇÑÇʵ带 'Y'·Î ÇÑ user Å×ÀÌºí ¸ñ·Ï¸¸ ¸¸µé¸é µÈ´Ù´Â °Í À» ±â¾ïÇÏÀÚ. db ³ª host Å×ÀÌºí ¸ñ·ÏÀº ÇÊ¿ä¾ø´Ù. (** °ü¸®ÀÚ ±ÇÇÑÀº db³ª host Å×ÀÌ ºí°ú´Â ÀüÇô °ü·ÃÀÌ ¾ø´Ù. db´Â Á¢¼ÓÇÒ ¼ö ÀÖ´Â µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ »ó¼¼ÇÏ°Ô ¼³Á¤ÇÏ °í host Å×À̺íÀº dbÅ×À̺íÀ» Á» ´õ Á¤±³ÇÏ°Ô ¼³Á¤Çϱâ À§ÇØ ÇÊ¿äÇÑ °ÍÀÌ´Ù. °ü¸®ÀÚ ±ÇÇÑÀº ¿ÀÁ÷ user Å×ÀÌºí¸¸ °ü·ÃµÇ¾îÀÖ´Ù **) ¸¶Áö¸· INSERT ¹®(dummy »ç¿ëÀÚ)¿¡¼´Â user Å×À̺íÀÇ ±ÇÇÑ Ä÷³ÀÌ ¸íÈ®ÇÏ°Ô ¼³Á¤µÇ Áö ¾Ê¾Ò´Ù. ¿Ö³Ä¸é ÀÌ Ä÷³ÀÇ ±âº»°ªÀº 'N'·Î µÇ¾î Àֱ⠶§¹®ÀÌ´Ù. ´ÙÀ½ÀÇ ¿¹Á¦¿¡¼´Â custom À̶ó´Â »ç¿ëÀÚ¸¦ Ãß°¡ÇÑ´Ù. customÀº localhost, server.domain, whitehouse.gov¿¡¼ Á¢¼ÓÇÒ ¼ö ÀÖ´Ù. localhost¿¡¼´Â bankaccount µ¥ ÀÌÅͺ£À̽º¿¡¸¸ Á¢¼ÓÇÒ ¼ö ÀÖÀ¸¸ç whitehouse.gov¿¡¼´Â expenses µ¥ÀÌÅͺ£À̽º¿¡, ¸ð µç ¼¼ È£½ºÆ®»ó¿¡¼´Â customer µ¥ÀÌÅͺ£À̽º¿¡ Á¢¼ÓÇÏ±æ ¿øÇÑ´Ù. ¸ðµç ¼¼ È£½ºÆ®»ó¿¡ ¼ stupid¶ó´Â ºñ¹Ð¹øÈ£¸¦ »ç¿ëÇÏ±æ ¿øÇÑ´Ù. GRANT ¹®À» ÀÌ¿ë ÀÌ·¯ÇÑ »ç¿ëÀÚ ±ÇÇÑÀ» ¼³Á¤Çϱâ À§ÇØ ´ÙÀ½ÀÇ ¸í·ÉÀ» ½ÇÇàÇÏÀÚ: shell> mysql --user=root mysql mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO custom@localhost IDENTIFIED BY 'stupid'; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON expenses.* TO custom@whitehouse.gov IDENTIFIED BY 'stupid'; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON customer.* TO custom@'%' IDENTIFIED BY 'stupid'; ½ÂÀÎ Å×À̺íÀ» Á÷Á¢ ¼öÁ¤ÇØ »ç¿ëÀÚ ±ÇÇÑÀ» ¼³Á¤ÇÏ·Á¸é ´ÙÀ½ÀÇ ¸í·ÉÀ» »ç¿ëÇÏÀÚ. (¸¶Áö ¸·¿¡ FLUSH PRIVILEGES ¸¦ »ç¿ëÇØ¾ß ÇÑ´Ù´Â °ÍÀ» ±â¾ïÇÏÀÚ): shell> mysql --user=root mysql mysql> INSERT INTO user (Host,User,Password) VALUES('localhost','custom',PASSWORD('stupid')); mysql> INSERT INTO user (Host,User,Password) VALUES('server.domain','custom',PASSWORD('stupid')); mysql> INSERT INTO user (Host,User,Password) VALUES('whitehouse.gov','custom',PASSWORD('stupid')); mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES ('localhost','bankaccount','custom','Y','Y','Y','Y','Y','Y'); mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES ('whitehouse.gov','expenses','custom','Y','Y','Y','Y','Y','Y '); mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES('%','customer','custom','Y','Y','Y','Y','Y','Y'); mysql> FLUSH PRIVILEGES; ~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~ óÀ½ÀÇ ¼¼°¡Áö INSERT ¹®Àº custom »ç¿ëÀÚ°¡ ºñ¹Ð¹øÈ£¸¦ »ç¿ëÇÏ¿© ´Ù¾çÇÑ È£½ºÆ®¿¡¼ Á¢¼ÓÇÒ ¼ö ÀÖµµ·Ï user Å×ÀÌºí ¸ñ·ÏÀ» Ãß°¡ÇÑ´Ù. ±×·¸Áö¸¸ ±×¿¡°Ô ¾î¶°ÇÑ Æ۹̼ǵµ ½Â ÀÎÇÏÁö ¾Ê´Â´Ù. (¸ðµç ±ÇÇÑÀº ±âº»°ªÀ¸·Î 'N' ÀÌ´Ù) ´ÙÀ½ÀÇ ¼¼°¡Áö INSERT ¹®Àº ÀûÀý ÇÑ È£½ºÆ®¿¡¼ Á¢¼ÓÀ» ÇÒ ¶§, custom ¿¡°Ô bankaccount, expenses, customer µ¥ÀÌÅͺ£ À̽º¿¡ ´ëÇÑ ±ÇÇÑÀ» ½ÂÀÎÇÏ´Â db Å×ÀÌºí ¸ñ·ÏÀ» Ãß°¡ÇÑ´Ù. ÀϹÝÀûÀ¸·Î ½ÂÀÎ Å×À̺íÀ» Á÷Á¢ ¼öÁ¤ÇÏ¿´À¸¸é, º¯°æµÈ ±ÇÇÑÀ» Àû¿ëÇϱâ À§ÇØ ¼¹ö°¡ ½ÂÀÎ Å×À̺íÀ» ´Ù½Ã Àеµ·Ï ÇØ ÁÖ¾î¾ß ÇÑ´Ù. ƯÁ¤ÇÑ »ç¿ëÀÚ°¡ ƯÁ¤ÇÑ µµ¸ÞÀÎÀÇ ½Ã½ºÅÛ¿¡¼ Á¢¼ÓÇÒ ¼ö ÀÖµµ·Ï ¼³Á¤ÇÏ°íÀÚ ÇÑ´Ù¸é, ´ÙÀ½°ú °°ÀÌ GRANT ¹®À» ¼³Á¤ÇÒ ¼ö ÀÖ´Ù: mysql> GRANT ... ON *.* TO myusername@"%.mydomainname.com" IDENTIFIED BY 'mypassword'; ½ÂÀÎ Å×À̺íÀ» Á÷Á¢ ¼öÁ¤ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇÑ´Ù: mysql> INSERT INTO user VALUES ('%.mydomainname.com', 'myusername', PASSWORD('mypassword'),...); mysql> FLUSH PRIVILEGES; ~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~ ½ÂÀÎ Å×À̺íÀ» ´Ù·ç±â À§ÇØ xmysqladmin, mysql_webadmin, xmysql ÇÁ·Î±×·¥À» »ç¿ëÇÒ ¼ö ÀÖ´Ù. http://www.mysql.com/Contrib ¿¡¼ ÀÌ·¯ÇÑ À¯Æ¿¸®Æ¼¸¦ ãÀ» ¼ö ÀÖ´Ù. 6.10 ºñ¹Ð¹øÈ£ ¼³Á¤ ¹æ¹ý ¾ÕÀÇ ¿¹Á¦´Â Áß¿äÇÑ ¿øÄ¢À» º¸¿©ÁØ´Ù : INSERT ³ª UPDATE ¹®¿¡¼ °ø¹éÀÌ ¾Æ´Ñ ºñ¹Ð¹ø È£¸¦ ÀúÀåÇÒ ¶§ ¹Ýµå½Ã ¾ÏÈ£ÈÇϱâ À§ÇØ PASSWORD() ÇÔ¼ö¸¦ »ç¿ëÇØ¾ß ÇÑ´Ù!! user Å× À̺íÀº ºñ¹Ð¹øÈ£¸¦ Ç÷¹ÀÎÅؽºÆ®(**ÀÏ¹Ý ÅؽºÆ® ÆÄÀÏ**)°¡ ¾Æ´Ï¶ó ¾ÏÈ£ÈµÈ ÇüÅ·ΠÀú ÀåÇϱ⠶§¹®ÀÌ´Ù. ÀÌ·¯ÇÑ »ç½ÇÀ» Àؾî¹ö¸®¸é ´ÙÀ½°ú °°ÀÌ ºñ¹Ð¹øÈ£¸¦ ¼³Á¤ÇÏ·Á°í ÇÒ °ÍÀÌ´Ù: shell> mysql -u root mysql mysql> INSERT INTO user (Host,User,Password) VALUES('%','jeffrey','bLa81m0'); mysql> FLUSH PRIVILEGES; Ç÷¹ÀÎÅؽºÆ® °ª 'bLa81m0' Àº user Å×ÀÌºí¿¡ ºñ¹Ð¹øÈ£·Î ÀúÀåÀÌ µÈ´Ù.jeffrey¶ó´Â »ç ¿ëÀÚ°¡ ÀÌ ºñ¹Ð¹øÈ£¸¦ »ç¿ëÇØ ¼¹ö¿¡ ¿¬°áÇÏ·Á°í ÇÒ ¶§ mysql Ŭ¶óÀ̾ðÆ®¸¦ ÀÌ ºñ¹Ð¹ø È£¸¦ ¾ÏÈ£ÈÇؼ ±× °á°ú¸¦ ¼¹ö·Î º¸³½´Ù. ¼¹ö´Â ¾ÏÈ£ÈµÈ ºñ¹Ð¹øÈ£('bLa81m0'ÀÌ ¾Æ ´Ï´Ù)¸¦ user Å×À̺íÀÇ ºñ¹Ð¹øÈ£(Ç÷¹ÀÎÅؽºÆ® 'bLa81m0' °ªÀÌ´Ù)¿Í ºñ±³ÇÑ´Ù. ºñ±³ ´Â ½ÇÆÐÇÏ°í ¼¹ö´Â ¿¬°áÀ» °ÅºÎÇÑ´Ù: shell> mysql -u jeffrey -pbLa81m0 test Access denied ºñ¹Ð¹øÈ£´Â user Å×ÀÌºí¿¡ ÀÔ·ÂµÉ ¶§ ¹Ýµå½Ã ¾ÏȣȵǾî¾ß Çϱ⠶§¹®¿¡, INSERT ¹®Àº ´ÙÀ½°ú °°ÀÌ »ç¿ëÇØ¾ß ÇÑ´Ù: mysql> INSERT INTO user (Host,User,Password) VALUES('%','jeffrey',PASSWORD('bLa81m0')); ¶ÇÇÑ SET PASSWORD ¹®À» »ç¿ëÇÒ ¶§µµ PASSWORD() ÇÔ¼ö¸¦ »ç¿ëÇØ¾ß ÇÑ´Ù: mysql> SET PASSWORD FOR jeffrey@"%" = PASSWORD('bLa81m0'); Âü°í : PASSWORD() ÇÔ¼ö´Â ºñ¹Ð¹øÈ£ ¾Ïȣȸ¦ ¼öÇàÇÑ´Ù. ±×·¸Áö¸¸ À¯´Ð½º¿¡¼ ºñ¹Ð¹ø È£¸¦ ¾ÏÈ£ÈÇÏ´Â ¹æ¹ý°ú´Â ´Ù¸£´Ù. À¯´Ð½º ºñ¹Ð¹øÈ£¿Í mysql ºñ¹Ð¹øÈ£°¡ µ¿ÀÏÇÒ ¶§ PASSWORD() °¡ À¯´Ð½º ºñ¹Ð¹øÈ£ ÆÄÀÏ(** /etc/passwd ÆÄÀÏ **)¿¡ ¾ÏȣȵǾî ÀúÀåµÈ °ª°ú °°´Ù°í »ý°¢ÇÏ¸é ¾È µÈ´Ù. GRANT ... IDENTIFIED BY ¹®À̳ª mysqladmin password ¸í·ÉÀ» »ç¿ëÇØ ºñ¹Ð¹øÈ£¸¦ ¼³Á¤ Çϸé PASSWORD() ÇÔ¼ö´Â ÇÊ¿ä¾ø´Ù. µÑ´Ù ºñ¹Ð¹øÈ£¸¦ ¾ÏÈ£ÈÇؼ ÀúÀåÇÑ´Ù: mysql> GRANT USAGE ON *.* TO jeffrey@"%" IDENTIFIED BY 'bLa81m0'; shell> mysqladmin -u jeffrey password bLa81m0 (** ´ç±Ù, GRANT ¹®À̳ª mysqladmin password ¸í·ÉÀ» »ç¿ëÇÏ´Â°Ô ÆíÇÏ°ÚÁö¿ä? mysql ÀÇ ¾ÏÈ£È ¾Ë°í¸®ÁòÀÌ À¯´Ð½º¿Í ´Ù¸£µí À¯´Ð½º °èÁ¤°ú mysqlÀÇ »ç¿ëÀÚ´Â ÀüÇô ´Ù¸£´Ù´Â °Íµµ ´Ù½Ã Çѹø ±â¾ïÇÏ°í ÀÖ¾î¾ß ÇÕ´Ï´Ù.**) |