Project Pier Update User Password

Hello,

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’;