Useful when you receive project delivery, and the idiot who delivers it forgets to tell you that the password is admin1234.
Instead of being stuck without being able to run your tests, you just need to apply the following SQL query:
UPDATE wp_users SET user_pass = MD5( 'new_password' ) WHERE user_login = 'your-username';