It is a step by step illustrated tutorial on How to change the WordPress admin password by editing MySQL database tables.
Some time we might face issues in changing admin password and it might have following reasons;
- If we forget password and unable to recover password using email password recover option due to server problem
- If some hacks WordPress login and changes the admin email
If you have one the following issue then don’t worry you still has opportunity to change your admin password and phpMyAdmin provides you this opportunity and you must have access to your Web Hosting control panel.
- First login to your Hosting control panel ( here we are telling about cPanel )
- Now go to the Database option Window and click on phpMyAdmin icon
- Now click on the database of your WordPress blog
- Here locate the table named “wp_users” and click on it
- You will find all users registered on your site
- Now locate the admin user and click on it
Here you can edit following values;
- Admin email
- Admin user name
- Admin password
- Admin display name etc
- You can not put changed password directly because WordPress keeps the passwords in encoded form (MD5 Hash) and you need to encode the desired changed password using an online encoder such as JavaScript MD5 or 7thSpace
- Generate MD5 coded password and enter it in password field and press “Go” button to save settings.
Note- If you seem your blog hacked then you should also change the admin email.
