Netkiller Cryptography 手札

信息安全与加密

$Id: book.xml 659 2013-08-09 10:01:31Z netkiller $

Copyright ? 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014 Netkiller. All rights reserved.

$Date: 2013-08-09 18:01:31 +0800 (Fri, 09 Aug 2013) $

7.1.?MySQL 加密函数

简单用法

			
mysql> select AES_ENCRYPT(‘helloworld‘,‘key‘);
+---------------------------------+
| AES_ENCRYPT(‘helloworld‘,‘key‘) |
+---------------------------------+
|                                 |
+---------------------------------+
1 row in set (0.00 sec)

mysql> select AES_DECRYPT(AES_ENCRYPT(‘helloworld‘,‘key‘),‘key‘);
+----------------------------------------------------+
| AES_DECRYPT(AES_ENCRYPT(‘helloworld‘,‘key‘),‘key‘) |
+----------------------------------------------------+
| helloworld                                         |
+----------------------------------------------------+
1 row in set (0.00 sec)

mysql>
			
			

加密数据入库

			
CREATE TABLE `encryption` (
	`mobile` VARBINARY(16) NOT NULL,
	`key` VARCHAR(32) NOT NULL
)
ENGINE=InnoDB;

INSERT INTO encryption(`mobile`,`key`)VALUES( AES_ENCRYPT(‘13691851789‘,md5(‘13691851789‘)), md5(‘13691851789‘)) 
select AES_DECRYPT(mobile,`key`), length(mobile) from encryption;