jim
with my vry little experteez what i do is
$password= time();
store this password into db
and mail it out to the member
all in the same file :)
what this does is not only a unique password for all my members its
also pretty difficult to apprehend . let alone anythin else
hope
what command are you using to change the password?
*if you are using GRANT then you don't need to use PASSWORD() function,
unless you use IDENTIFIED BY PASSWORD clause
*if you are using INSERT or SET then you need to use PASSWORD() function to
encrypt the password.
see the actual password stored