页次: 1
加密函数有三个 password(str), md5(str), encode(str, passwd_str)
解密函数 decode(str)
三个加密函数的用处是不同的, 第一个 password()是个不可解密的加密方式。单向的。
第二个:md5 值
第三个可以通过 decode 进行还原
mysql> select password('ipbbs.net'); +-------------------------------------------+ | password('ipbbs.net') | +-------------------------------------------+ | *E1247D8201FB9051D357A07A7AD0515AAF0B35F5 | +-------------------------------------------+ 1 row in set (0.00 sec) mysql> select md5('ipbbs.net'); +----------------------------------+ | md5('ipbbs.net') | +----------------------------------+ | 916df7583deb1bedd46190eb396c87d6 | +----------------------------------+ 1 row in set (0.00 sec) mysql> select encode('ipbbs.net'); mysql> select encode('ipbbs.net' , 'mima'); +------------------------------+ | encode('ipbbs.net' , 'mima') | +------------------------------+ | ROu(uP | +------------------------------+ 1 row in set (0.04 sec) mysql> select decode (encode('ipbbs.net', 'mima'), 'mima'); +----------------------------------------------+ | decode (encode('ipbbs.net', 'mima'), 'mima') | +----------------------------------------------+ | ipbbs.net | +----------------------------------------------+ 1 row in set (0.00 sec)
ipbbs.net
离线
页次: 1