– 1、加密:mysql323,不可逆,轉換成Hash密碼
select OLD_PASSWORD(‘123456’); 返回565491d704013245
– 2、加密:mysqlsha1,不可逆
select PASSWORD(‘123456’); 返回*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
– 3、加密:md5,不可逆
select MD5(‘123456’); 返回e10adc3949ba59abbe56e057f20f883e
– 4、加密解密:encode()和decode(),參數1:要编码的字符串,參數2:key
select ENCODE(‘password’, ‘mykey’); 返回鎭?怈Q
select DECODE(ENCODE(‘password’, ‘mykey’), ‘mykey’); 返回password
– 5、加密解密:aes_encrypt()和aes_decrypt(),比encode()和decode()安全性要高,參數1:要编码的字符串,參數2:key
select aes_encrypt(‘password’, ‘mykey’); 返回?>V7舾稂]?&
select aes_decrypt(aes_encrypt(‘password’, ‘mykey’), ‘mykey’); 返回password