Did ever happened to you that you are unable to login in a wordpress blog because you have not access to the email account?
There’s a way to recover your account without knowing the last password. The only thing you need is access to PhpMyAdmin and five minutes.
First step: access to PhpMyAdmin and go to the users table.
Second step: locate the row which needs the change, click the ‘Edit’ link.
Third step: The link will lead you to a form, locate in the form the value for the column ‘user_pass’. After that, you need to fill in the input your new password enconded in md5. Finally don’t forget to press the update button to save the row changes.
Tip: You can use services like md5.cz to encode a string to md5.
Shortcut: On second step, intead of use the ‘Edit’ link you can execute de following query:
UPDATE `wp_users` SET `user_pass`= MD5('yourpassword') WHERE `user_login`='yourusername';