I was moving a bunch of old old sites over to a new server the other day and thought i would make some changes to one of them... but realized I couldnt remember th User1 password.  Ha, shows you how well I keep that site up-to-date hu.  Now that its in Aegir, it will probably stay maintained better.

Here is the skinny on how I changed it...

Go into phpmyadmin and select your database:

Then click the SQL tab and enger in this command into the "Run SQL query/queries on database...":

UPDATE `users` SET pass = MD5('newpwd') WHERE uid=1;

We are basically telling the database to update the "users" table with the password "newpwd" (change this to the password you want) for only user 1 (uid=1).

This code can be found on drupal.org (if your wondering where I got it) right here: http://drupal.org/node/44164.