mysql加密函数

md5
password()


//案例
mysql> select md5('xiaodeng');
+----------------------------------+
| md5('xiaodeng')                  |
+----------------------------------+
| accd5818a8547b13180044139260c80d |
+----------------------------------+
1 row in set (0.09 sec)

mysql> select password('xiaodeng');
+-------------------------------------------+
| password('xiaodeng')                      |
+-------------------------------------------+
| *37F20A3D69B0CE32DE36C6D57BFB0408A63F80DE |
+-------------------------------------------+
1 row in set, 1 warning (0.05 sec)

 

posted @ 2016-10-30 14:00  Xiao|Deng  阅读(1027)  评论(0编辑  收藏  举报