How to: change WordPress user password with MySQL

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.
2016-07-23 15_20_39-Settings

Tip: You can use services like 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';

Published by

Alí Adame

I'm an enthusiastic of technology as a way to improve life quality and bring progress to every person and organizations. My actual interest are based on software and web development and project management. || Soy un entusiasta de la tecnología como medio para lograr una mejor calidad de vida y progreso en todas las personas y las organizaciones. Mis intereses personales se centran en desarrollo de software, desarrollo web y administración de proyectos.

Leave a Reply

Your email address will not be published. Required fields are marked *