Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2012/03/31(00:01) from 110.12.189.244 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 4190 , ÁÙ¼ö : 40 |
[MySQL] µ¥ÀÌÅ;ÏÈ£È (Encrypt/Decrypt) |
---|
1. ¾ÏÈ£ÈÇÏ¿© µ¥ÀÌÅ͸¦ »ðÀÔÇÒ Ä÷³ÀÇ ¼Ó¼ºÀ» ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ 256 ¹Ì¸¸ÀÇ ¹®ÀÚÀÎ °æ¿ì tinyblob 63535 ¹Ì¸¸ÀÇ ¹®ÀÚÀÎ °æ¿ì blobÀ¸·Î º¯°æ mysqlÀº ¿©·¯ ¾ÏÈ£È ÇÔ¼ö¸¦ Á¦°øÇÑ´Ù. º°µµÀÇ API ¾øÀÌ Äõ¸®¹®À¸·Î ¾ÏÈ£ÈÇÏ¿© Å×ÀÌºí¿¡ ³Ö°í º¹È£ÈÇÏ¿© ²¨³½´Ù. Å×ÀÌºí ±¸¼ºÀÌ ¾Æ·¡¿Í °°´Ù°í °¡Á¤ÇÏÀÚ. member Å×À̺í user_id varchar(32) password tinyblob 2. Æнº¿öµå ¾ÏÈ£ÈÇÏ¿© ³Ö±â insert into member (user_id, password) values ('asbds', AES_ENCRYPT('pass', 'key')); ¿©±â¼ key´Â ¾ÏÈ£È/º¹È£È Å°ÀÌ´Ù. 'pass'´Â ¾ÏÈ£ÈÇÒ ¹®ÀÚ¿ ¿©±â¼´Â Æнº¿öµå´Ù update member set password = AES_ENCRYPT('pass', 'key') where user_id = 'asdbs'; 3. Æнº¿öµå º¹È£ÈÇÏ¿© ²¨³»±â ¿©±â¼ select½Ã Æнº¿öµå¸¦ º¹È£ÈÇÏ¿© ²¨³»±â À§Çؼ´Â *¸¦ »ç¿ëÇÒ ¼ö ¾ø´Ù. select user_id, AES_DECRYPT(password, 'key') where user_id = 'asdbs'; AES_DECRYPTÀÇ Ã¹¹ø° ÀÎÀÚ´Â ÇØ´ç Ä÷³¸íÀÌ´Ù. |