Reset Password for a LAMP webapp

Assuming the webapp uses the standard php functions and without a salt, an example like the following for weberp will work:

nic@www:/export/apps/weberp$ echo "<?php print sha1('password') . \"\n\";?>" | php;
5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8

UPDATE www_users SET password = '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8' WHERE userid = 'nlee';

Note this changes the password to “password”.