Re: MySQL Password Encryption

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



mysql> insert into fc_Customer (User_Password) values(password("abcd"));
Query OK, 1 row affected (0.00 sec)


However, when I try to select the line by searching on the password here is
the response:


mysql> select * from fc_Customer where User_Password=password("abcd");
Empty set (0.00 sec)


I can view see that the record was added and that the password was
encrypted, but I can't compare it or select it using password function.

Make sure that the column width is long enough (16, I believe). It's possible that the inserted encrypted value is being truncated.


Larry


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux