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]';

Last modified: 30/05/2006 (most likely earlier as a site migration in 2006 reset some dates) Tags: (none)