How to reset the password of user 1
Last modified: November 8, 2008 - 20:38
If you forget the password or otherwise need to gain access to the Drupal administrative user account (user/1), you can run the following SQL on the database:
UPDATE `users` SET `pass` = MD5('mynewpassword') WHERE `uid` =1;
where mynewpassword is the new password you'd like to use.

Mesma solução em portugues
Como tinha colocado no meu Blog, resolvi deixar aqui tambem.
http://www.leomangione.com.br/2009/11/03/como-reiniciar-a-senha-do-super...
Cms Adminstrator
Working at @viva_rio
www.leomangione.com.br
Twitter : @leomangione