Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2002/08/05(10:31) from 210.117.182.162 | |
ÀÛ¼ºÀÚ : °ÁÙ±â (jkkang65@hanmail.net) | Á¶È¸¼ö : 4491 , ÁÙ¼ö : 16 |
Re: [MySQL] ¿ø°ÝÁ¢¼Ó - grant »ç¿ë¹ý |
---|
local »óÅ¿¡¼ root ·Î´Â ´ÙÀ½ÀÇ ¸í·É¾î¸¦ »ç¿ëÇÒ¼ö ÀÖ´Ù. # mysqlshow mysql ÇÏÁö¸¸, mysql id·Î´Â À§ÀÇ ¸í·É¾î¸¦ »ç¿ëÇÒ¼ö°¡ ¾ø´Ù. ±×°ÍÀ» À§Çؼ´Â grant ±ÇÇÑÀ» Áà¾ß¸¸ ÇÑ´Ù. # mysql -u root -p mysql mysql> grant all privileges on myDB.* to jkkang@loopback identified by 'password' with grant option; mysql> flush privileges; @ to flush # mysqladmin -u root -p mysql reload |