Thanks Liam – this worked. Note the following:
Ajenti Server MySQL query input doesn’t like single quotes around table names or column names. So, I had to use the following format:
UPDATE wp_users SET user_pass= MD5(‘yourpassword’) WHERE user_login=’yourusername’;