Monday, October 25, 2010

Project Pier Update User Password


In the table called pp_users, you will find the line corresponding to the admin account. Note the salt value from the table pp_user Or you can copy / paste the salt value directly into the mysql update command.
To modify the password of the admin / user account, use the below mysql statement.
Here in the below mysql statement,
sha1 (Function)
(salt value)
adminpassword (user password)
update pp_users SET token = sha1(“”) where username = ‘admin’;

No comments: