sword ) FROM user WHERE username='someuser' AND
> password=password( 'plaintextpass' );
>
> Regards,
> Luke Davison
>
> - Original Message -----
> From: "rory oconnor" <[EMAIL PROTECTED]>
> To: "perl" <[EMAIL PROTECTED]&
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
plaintextpass' );
Regards,
Luke Davison
- Original Message -
From: "rory oconnor" <[EMAIL PROTECTED]>
To: "perl" <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 9:08 PM
Subject: Password Encryption for MySQL field
> I'm writing a small perl scri
I'm writing a small perl script that will help web users manage an
"account" (i.e. their record in a mysql table). I want to store their
password in a field, but I don't want to store it in regular text. I'm
not sure if this is a perl or MySQL function, but I think there is some
method of "encry
