Reset WordPress user password

WordPress has a very good guide for doing this here. But in short it really is this mysql command that does the magic, just replace the prefix wp_ with the one used at your site:

UPDATE wp_users SET user_pass=MD5('your_secret_password') WHERE user_login='';

Hope this will help you 🙂