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

mysql:14598

From: <kozu@xxxxxxxxxx>
Date: Sat, 7 Jun 2008 00:42:36 +0900 (JST)
Subject: [mysql 14598] Re: ¸¢¸Â¤Ë¤Ä¤¤¤Æ

ÃæÉÙ¤µ¤ó

¤³¤ó¤Ð¤ó¤Ï¡¢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>   ]