insert user(userid,passwd) values('abc',PASSWORD('123'))
成功后
select * from user where passwd=PASSWORD('123')
却找不到相关记录,高人指点mysql 版本
执行 mysql --version
mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32)
成功后
select * from user where passwd=PASSWORD('123')
却找不到相关记录,高人指点mysql 版本
执行 mysql --version
mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32)
select * from mysql.user where password=password('admin')
可以查询出来.
这个时候你就要用OLD_PASSWORD()函数了。
Query OK, 1 row affected (0.11 sec)
Records: 1 Duplicates: 0 Warnings: 0mysql> select * from tmp where password('123')=pass;
+-------------------------------------------+
| pass |
+-------------------------------------------+
| *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
+-------------------------------------------+
1 row in set (0.00 sec)mysql> select version();
+------------------------------------+
| version() |
+------------------------------------+
| 5.1.17-beta-community-nt-debug-log |
+------------------------------------+
1 row in set (0.00 sec)
from [user]