MySQL数据库password函数原型

mysql> select password('123456');
+-------------------------------------------+
| password('123456') |
+-------------------------------------------+
| *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+-------------------------------------------+
1 row in set (0.00 sec)

 

mysql> select concat('*',upper(sha1(unhex(sha1('123456')))));
+------------------------------------------------+
| concat('*',upper(sha1(unhex(sha1('123456'))))) |
+------------------------------------------------+
| *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+------------------------------------------------+
1 row in set (0.00 sec)