» Resetting Your Password « WordPress Codex
When you have access to the mySQL database through phpAdmin, but not the normal Wordpress admin login.
