一 加密函数PASSWORD(str)
mysql> select password('newpwd');
+-------------------------------------------+
| password('newpwd') |
+-------------------------------------------+
| *1FA85AA204CC12B39B20E8F1E839D11B3F9E6AA4 |
+-------------------------------------------+
1 row in set, 1 warning (0.03 sec)
二 加密函数MD5(str)
mysql> select md5('mypwd');
+----------------------------------+
| md5('mypwd') |
+----------------------------------+
| 318bcb4be908d0da6448a0db76908d78 |
+----------------------------------+
1 row in set (0.01 sec)
三 加密函数ENCODE(str,pswd_str)
mysql> select encode('secret','cry'),length(encode('secret','cry'));
+------------------------+--------------------------------+
| encode('secret','cry') | length(encode('secret','cry')) |
+------------------------+--------------------------------+
| úhû | 6 |
+------------------------+--------------------------------+
1 row in set, 2 warnings (0.01 sec)
四 DECODE(str,pswd_str)
mysql> select decode(encode('secret','cry'),'cry');
+--------------------------------------+
| decode(encode('secret','cry'),'cry') |
+--------------------------------------+
| secret |
+--------------------------------------+
1 row in set, 2 warnings (0.00 sec)