1 = Managing Staff from the Command Line =
3 == Changing passwords ==
5 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.
7 Connect to your Evergreen database using _psql_ or similar tool, and retrieve and verify your admin username:
10 ------------------------------------------------------------------------------
11 psql -U <user-name> -h <hostname> -d <database>
13 SELECT id, usrname, passwd from actor.usr where usrname = 'admin';
14 ------------------------------------------------------------------------------
16 If you do not remember the username that you set, search for it in the _actor.usr_ table, and then reset the password.
19 ------------------------------------------------------------------------------
20 UPDATE actor.usr SET passwd = <password> WHERE id=<id of row to be updated>;
21 ------------------------------------------------------------------------------
23 The new password will automatically be hashed.