OK, this is neat, but I can't seem to get it to wrok correctly. I can
insert it just fine (i see the encrypted password in the field), but
when I try to select it using the plain text password I can't.
(using perl) for inserting:
$insert_user = "insert into $table (email,password,date) VALUES
(
Ooops! Correction:
Incorrect -- connect("DBI:mysql:HOST", "DB", 'DB_PASSWORD');
Should be -- connect( "dbi:mysql:dbname", "username", 'DBpassword');
Ron
===
"Ron" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
This is my two-
This is my two-bits on your question. I hope this helps.
Ex: ENCODE('str', 'password') str is the string of the chosen password and
password is the mySQL encryption password for encoding/decoding the password
string.
ENCODES returns a binary string and may be decoded with DECODE(). You
should
Rory,
I would recommend using MySQL's buit in password() function:
INSERT INTO user ( username,password ) VALUES ( 'someuser', password(
'plaintextpasshere' ) );
SELECT ( username, password ) FROM user WHERE username='someuser' AND
password=password( 'plaintextpass' );
Regards,
Luke Davison
--
