24th June 01:42
i'm doing this from the command line of mysql
select * from mydb.user where password =3D 'tom';
this doesn't work
this doesn't work either.
I inserted the record by:
insert into user values ('tom', 'email_address', password('tom'));
From: William Curry [mailto:email@example.com]
Sent: Friday, October 10, 2003 11:28 AM
To: Gerardo Rojas
Subject: Re: passwords
if ($userid && $password)
$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;
Computer Services Specialist
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 ?????
password =3D 'plain text password'
password =3D password('plain text password')
nothing seems to work!
Gerardo S. Rojas
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dmysqlfirstname.lastname@example.org