password函数的结果,2.2版本与2.1版本存在差异
2.2.2版本结果:
MySQL [sjfx_db]> select password(‘3wS_r7UHc’);
±--------------------------------------------+
| ‘*9CCAEC80606934691620176B6B3AC1553070D7A8’ |
±--------------------------------------------+
| *9CCAEC80606934691620176B6B3AC1553070D7A8 |
±--------------------------------------------+
1 row in set (0.01 sec)
2.1.8版本结果:
mysql> select password(‘3wS_r7UHc’);
±--------------------------------------------+
| ‘*0B5CED987A45262765BB7DEE0EB00483E4AD82D0’ |
±--------------------------------------------+
| *0B5CED987A45262765BB7DEE0EB00483E4AD82D0 |
±--------------------------------------------+
1 row in set (0.01 sec)
经过验证2.1版本的结果与mysql数据库一致