How to reset the admin/UID#1 Drupal user

Lost your admin password for Drupal?
 
Need to reset UID #1?

 
mysql -u root -p
use drupaldbname;
UPDATE users SET pass = md5('newpassword') WHERE uid = 1;
/q