Re: user need password

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" <burney@gseis.ucla.edu> To: "andrie" <andrie@ajk.its-sby.edu>; <php-db@lists.php.net> Sent: Thursday, May 17, 2001 1:44 AM Subject: Re: [PHP-DB] user need password > on 5/16/01 10:44 PM, andrie at andrie@ajk.its-sby.edu 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >