MySQL中可以通过以下两种方式加密:
MD5()
PASSWORD()
1、MD5加密可以得到32位加密结果
mysql> SELECT MD5('张三');
+----------------------------------+
| MD5('张三') |
+----------------------------------+
| 615db57aa314529aaa0fbe95b3e95bd3 |
+----------------------------------+
mysql> SELECT LENGTH(MD5('张三'));
+-----------------------+
| LENGTH(MD5('张三')) |
+-----------------------+
| 32 |
+-----------------------+
2、PASSWORD加密一般用于对用户密码加密
mysql> SELECT PASSWORD('张三');
+-------------------------------------------+
| PASSWORD('张三') |
+-------------------------------------------+
| *20AE7F426AD9000FA2F167D2CA9874E664502AED |
+-------------------------------------------+
1 row in set (0.01 sec)
mysql> SELECT LENGTH(PASSWORD('张三'));
+----------------------------+
| LENGTH(PASSWORD('张三')) |
+----------------------------+
| 41 |
+----------------------------+