Useful SQL

Unblock a user with role id 1 (i.e. the admin user):

UPDATE modx_user_attributes SET blockeduntil=0 WHERE id=1;

Change the password of [username] to [password]:

UPDATE modx_manager_users SET password=MD5('[password]') WHERE username='[username]';