This is a handy bit to know when you get a db dump and don't know the admin password that's been setup. (And are too impatient to wait for an email response? :P )

update users set pass=md5('kittens') where uid=1

Replace kittens with desired password. This effects User ID 1 (admin).