you can however not use the password function and use the encode and decode
function where you can specify your own encryption key. In that way you can
decode a password.
insert into user (password) values (encode('$password','$passkey'));
select decode($password,$passkey) from users where username = "$username";
I may have the variables backwards, but you get the idea.
Curtis
----- Original Message -----
From: "Paul Burney" <[EMAIL PROTECTED]>
To: "andrie" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 1:44 AM
Subject: Re: [PHP-DB] user need password
> on 5/16/01 10:44 PM, andrie at [EMAIL PROTECTED] wrote:
>
> > we know that every password in mysql was encryption using PASSWORD
> > function. i have case that make me to send user password bymail.
> > how can i get this user password ?
>
> You can't. It's a one way encryption. You'll need to log into MySQL as
> root and set the password to a new password that you can send to the user.
>
> Paul
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
