password query

[slava_php]

hi,
i have a table user_info with column user_pass.
here's my insert query:
" insert into user_info (user_id, user_pass) values ('steve', password('test')) "

it inserts fine.

i can't select

" select * from user_info where user_id = 'steve' and user_pass = password('test') "

where's the mistake?

thanks,
steve

[tonyndory]

What are you using the Password() function for?

from the manual:

This is the function that is used for encrypting MySQL passwords for storage in the Password column of the user grant table

If you are storing passwords to your own web application, I'd consider using something like ENCODE()...

again from the manual:

ENCODE(str,pass_str)
Encrypt str using pass_str as the password. To decrypt the result, use
DECODE().
The results is a binary string of the same length as string. If you want to save
it in a column, use a BLOB column type.
DECODE(crypt_str,pass_str)
Descrypts the encrypted string crypt_str using pass_str as the password.
crypt_str should be a string returned from ENCODE().