I should have suggested the use of the ENCRYPT() function, not CRYPT() (since the latter, like PASSWD(), doesn't exist! ;) . Thus, the update query should properly be: UPDATE vpopmail SET pw_passwd=ENCRYPT('newpassword') WHERE pw_user='someuser'; Sorry for the confusion... /pg -- Peter Green : Gospel Communications Network, SysAdmin : [EMAIL PROTECTED] --- I made that book [_Sex_] because...uh...because...um...uh...I don't know *why* I made that book. (Madonna, to David Letterman)
- RE: oops, wrong MySQL function Peter Green
- RE: oops, wrong MySQL function hari_bhr