Managing Staff from the Command Line ==================================== Changing passwords ------------------ If you need to change a patron or staff account password without using the staff client, here is how you can reset it with SQL. Connect to your Evergreen database using _psql_ or similar tool, and retrieve and verify your admin username: [source, sql] ------------------------------------------------------------------------------ psql -U -h -d SELECT id, usrname, passwd from actor.usr where usrname = 'admin'; ------------------------------------------------------------------------------ If you do not remember the username that you set, search for it in the _actor.usr_ table, and then reset the password. [source, sql] ------------------------------------------------------------------------------ UPDATE actor.usr SET passwd = WHERE id=; ------------------------------------------------------------------------------ The new password will automatically be hashed.