[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

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>   ]