grojas

i'm doing this from the command line of mysql

select * from mydb.user where password =3D 'tom';

this doesn't work

=3D password('tom');

this doesn't work either.

I inserted the record by:

insert into user values ('tom', 'email_address', password('tom'));

-----Original Message-----
From: William Curry [mailto:currywm@ci.champaign.il.us]
Sent: Friday, October 10, 2003 11:28 AM
To: Gerardo Rojas
Subject: Re: passwords


if ($userid && $password)
{

$db_conn=3DconnNotes();
mysql_select_db("metnotes",$db_conn);
$result =3D mysql_query("select * from tblusersettings where User =3D
'$userid' AND passworde=3D'$password'");
if (mysql_num_rows($result) > 0 )
{
$valid_user =3D $userid;
session_register("valid_user");
}

}

Bill Curry
Computer Services Specialist
METCAD
217-333-4398


I have created a user table with passwords that are hashed. Now how do
I check (authenticate) that user.

select * from mytable.user where password =3D ?????

I've tried:

password =3D 'plain text password'
password =3D password('plain text password')

nothing seems to work!

--
Gerardo S. Rojas
mailto: grojas@strategicinc.com=20

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dmysql-win32@freebsd.csie.nctu.edu.tw