MD5：密碼為web頁面做準備，建議使用MD5
PASSWORD() :修改當前用戶或其他用戶密碼
mysql> SELECT MD5('admin'); ?#對admin進行MD5的加密（32位）
+----------------------------------+
| MD5('admin') |
+----------------------------------+
| 21232f297a57a5a743894a0e4a801fc3 |
+----------------------------------+
1 row in set (0.01 sec)
mysql> SELECT PASSWORD('admin'); ?# 進行密碼的計算
+-------------------------------------------+
| PASSWORD('admin') |
+-------------------------------------------+
| *4ACFE3202A5FF5CF467898FC58AAB1D615029441 |
+-------------------------------------------+
1 row in set (0.00 sec)
mysql>
mysql> SET PASSWORD=PASSWORD('dimitar'); ?#把當前用戶密碼修改為dimitar
Query OK, 0 rows affected (0.02 sec)
?
)
