Lancer Emotion 16 wrote:
I have this table named users :
+
| ID | user | pass | thegroup | firstname | surname | enabled
+----+--------+----------------------+----------+-----------+---------+---------
| 1 | Admin | *4ACFE3202A5FF5CF467 | 1 | Mr | Admin | 1
The password in both cases are : admin .
When i do any of this querys :
select * from users where pass=password("admin");
that one should work, except...
When i do :
select password('admin')
i get : *4ACFE3202A5FF5CF467898FC58AAB1D615029441
You wouldn't maybe guess that your "pass" field above is too small? :-)
FWIW,
--
Hassan Schroeder ----------------------------- [EMAIL PROTECTED]
Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
dream. code.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]