Re: MySQL Password Encryption

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

 



Try using:
  mysql> select * from fc_Customer where User_Password='abcd';


At 12:21 PM 5/8/2003 -0600, you wrote:
Hi,

I was wondering if I could get some MySQL help for the PHP file I'm writing.
I'm using the password command to encrypt my passwords in MySQL.  Here is a
simple line:

   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.

Can someone please help.

Thanks!!!

Doug Coning





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

Jadiel Flores ------------------------- http://www.abargon.com jflores@abargon.com (52-55) 52-29-80-34



--
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