To examplify this:
When you add your user, do it like you do now:
insert into a values (password('name'));
When the user logs in at a later time, do this:
select * from a where pw = password('name');
If no row is selected, no user with that password was found.
- Carsten
----- Original Message -----
From: "Al Caponi" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 7:18 AM
Subject: RE: encrypt password
> http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
>
> Using the PASSWORD function is an irreversible process. Check the above
> link.
>
> A work around is you always deal with the encrypted password on the server
> side.
> E.g. When the user will login you encrypt the submitted password and do a
> SELECT with the resulting String.
>
> Regards,
> Al
>
> > -----Original Message-----
> > From: Manish Mehta [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, March 04, 2002 2:12 PM
> > To: mysql
> > Subject: encrypt password
> >
> >
> > Hi ,
> >
> > I am working in mysql . with the help of password() function I insert
the
> > data in some table .
> >
> > for example :-
> >
> > insert into a values (password('name'));
> >
> > when I fire select query . It shows me this -> 23e6065b74
> >
> > I wants to decrypt the data again in same format as I insert with Select
> > query.
> >
> > please tells me the process .
> >
> > Thx in advance
> >
> > Manish Mehta
> >
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
