As a system admin, we all are supposed to know how to the backend.

1.) Find the database name in “wp-config.php” for the corresponding WP domain.mysql (1)

2.) Take backup
root@hostname#mysqldump databasename > databasename.sql

3.) Enter into MySQL prompt.


mysql> use databasename;

mysql> show tables;

4.) Check for ‘wp_users’ table.

mysql> select * from wp_users; (To check username)

mysql> update wp_users set user_pass=MD5(‘GIVE_STRONG_ADMIN_PASSWORD_HERE’) where user_login=”admin”;

mysql> quit.

Now, try to access WordPress using new password….:)

One thought on “How To Reset WordPress admin password from Backend

  1. Hey There. I discovered your blog using msn. That is a really neatly written article. I’ll make sure to bookmark it and return to learn more of your helpful info. Thank you for the post. I will certainly return.|

Leave a Reply

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