Reset your password in WordPress

Ever wanted to reset your password in WordPress, but cannot seem to use the reset password section whatever the reason?

SQL Query:

UPDATE wp_users SET user_pass = MD5( 'new_password' ) WHERE user_login = 'your-username';