Reset a WordPress password with a SQL query

UPDATE wp_users
   SET user_pass = MD5('new-secret')
 WHERE user_login = 'admin';