mysql:14599
From: <kozu@xxxxxxxxxx>
Date: Sat, 7 Jun 2008 00:47:55 +0900 (JST)
Subject: [mysql 14599] Re: ¸¢¸Â¤Ë¤Ä¤¤¤Æ
ÃæÉÙ¤µ¤ó kozu ¤Ç¤¹¡£ ¤¹¤ß¤Þ¤»¤ó¡¢¥á¡¼¥ëºîÀ®ÅÓÃæ¤ÇÁ÷¿®¤·¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡£ ¤Á¤Ê¤ß¤Ë¡¢¸½¾Ý¤ò³Îǧ¤·¤¿¤Î¤Ï°Ê²¼¤Î¥Ð¡¼¥¸¥ç¥ó¤Ç¤¹¡£ ¡¦mysql-server-5.0.22-2.2.el5_1.1 (CentOS5.1 ¤Î RPM) ¡¦mysql5.0.51a (¥½¡¼¥¹¤«¤é¥¤¥ó¥¹¥È¡¼¥ë) ¡¦mysql4.0.30 (¥½¡¼¥¹¤«¤é¥¤¥ó¥¹¥È¡¼¥ë) ¤Þ¤º¡¢»ä¤Î½ê¤Ç¤À¤±µ¯¤¤Æ¤¤¤ë¸½¾Ý¤«¤É¤¦¤«¤ò³Îǧ¤·¤¿¤¤¤Î¤Ç¤¹¤¬¡¢ ³§ÍͤδĶ¤Ç¤Ï¤¤¤«¤¬¤Ç¤·¤ç¤¦¤«¡©¡© ¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£ > ÃæÉÙ¤µ¤ó > > ¤³¤ó¤Ð¤ó¤Ï¡¢kozu ¤Ç¤¹¡£ > > ÃæÉÙ¤µ¤ó¤«¤é夤¤¿¥¢¥É¥Ð¥¤¥¹¤òƧ¤Þ¤¨¡¢ > ¾ðÊóÄ󶡸µ¤Ç¤¢¤ë¿ÈÆâ¤Î¾ðÊó¤ò¾ÜºÙ¤Ë³ÎǧÃפ·¤Þ¤·¤¿¤é¡¢ > ¿·¤¿¤Ê»ö¤¬È½ÌÀÃפ·¤Þ¤·¤¿¡£ > (»ä¼«¿È¤¬¸½¾Ý¤òÀµ¤·¤¯Íý²ò¤·¤Æ¤¤¤Þ¤»¤ó¤Ç¤·¤¿^^;) > > > »ä¤Î¸¡¾Ú´Ä¶ CentOS5.1 ¤Ë yum ¤Ç mysql5.0 ¤òÆþ¤ì¤Æ¡¢ > ¿§¡¹»î¤·¤¿·ë²Ì¡¢°Ê²¼¤Î SQL ¤òȯ¹Ô¤¹¤ë¤È¡¢ > testuser ¤Ï test_db2 ¤òºîÀ®¤¹¤ë»ö¤Ï½ÐÍè¤Ê¤¤¤¬¡¢ > `test?db1` ¤Ç¤¢¤ì¤ÐºîÀ®¤Ç¤¤ë¤È¤¤¤¦¥Ð¥°¤Î¤è¤¦¤Ê¸½¾Ý¤¬µ¯¤¤Æ¤¤¤Þ¤¹¡£ > > ¡ testuser ¤òºîÀ® > insert into mysql.user (host,user,password) > values ('%','testuser',PASSWORD('$password')); > > ¢ ¸¢¸Â¤òÉÕÍ¿ > insert into mysql.db > (host,db,user,Select_priv,Insert_priv,Update_priv, > Delete_priv,Create_priv,Drop_priv,References_priv,Index_priv, > Alter_priv,Create_tmp_table_priv,Lock_tables_priv) > values > ('%','test_db1','testuser','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); > > £ testuser ¤Ç¥í¥°¥¤¥ó > ¤ test_db2 ¤ÏºîÀ®¤¹¤ë»ö¤¬½ÐÍè¤Ê¤¤¤¬¡¢test_db1 ¤Ç¤¢¤ì¤ÐºîÀ®¤¬½ÐÍè¤Æ¤·¤Þ¤¦¡£ > ¤Ê¤ª¡¢create database `test?db1` ¤Î¤è¤¦¤Ë¡¢ > ¥Ð¥Ã¥¯¥¯¥ª¡¼¥ÈÉÕ¤¤Ç¥¯¥¨¥ê¡¼¤òȯ¹Ô¤¹¤ë¤Î¤¬¥ß¥½¤Î¤è¤¦¤Ç¤¹¡£ > > ¤Á¤Ê¤ß¤Ë¡¢GRANT¤ò»È¤Ã¤¿¾ì¹ç¤Ç¤âƱÍͤǤ¹¡£ > »ä¤Ï°Ê²¼¤Î¼ê½ç¤Ç¸½¾Ý¤ò³Îǧ¤·¤Þ¤·¤¿¡£ > > ¡ ¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ® > create database `test_db1`; > ¢ GRANT > GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP > ON test_db1.* TO testuser@localhost IDENTIFIED BY 'testtest'; > £ testuser ¤Ç¥í¥°¥¤¥ó > ¤ test_db2 ¤ÏºîÀ®¤¹¤ë»ö¤¬½ÐÍè¤Ê¤¤¤¬¡¢test_db1 ¤Ç¤¢¤ì¤ÐºîÀ®¤¬½ÐÍè¤Æ¤·¤Þ¤¦¡£ > > > >
14594 2008-06-06 22:06 [<kozu@xxxxxxxxxx> ] ¸¢¸Â¤Ë¤Ä¤¤¤Æ 14595 2008-06-06 22:35 ¨±[Katsutoshi Nakatomi ] 14596 2008-06-06 23:24 ¡¡¨±[<kozu@xxxxxxxxxx> ] 14597 2008-06-06 23:47 ¡¡¡¡¨±[Katsutoshi Nakatomi ] 14598 2008-06-07 00:42 ¡¡¡¡¡¡¨±[<kozu@xxxxxxxxxx> ] -> 14599 2008-06-07 00:47 ¡¡¡¡¡¡¡¡¨±[<kozu@xxxxxxxxxx> ] 14600 2008-06-07 02:42 ¡¡¡¡¡¡¡¡¡¡¨±[<kozu@xxxxxxxxxx> ]