There may happen certain incidences like for some reason if your site is hacked, or something else, you are no longer able to login to your admin panel using the login information, and you are not able to reset the password via email. But, you want to change the password immediately.
In situations like this phpMyAdmin may be an essential tool to overcome the problem. Every wordpress blog is accessed by a database and every database can be mannaged by phpMyAdmin.
So, we can easily change the wordpress credentials by acessing the phpMyAdmin.
1.Find out the name of the database:
There is a file wp-config.php under your root WordPress Directory. This file contains the database name where the wordpress is installed. You can find the databse name from the line similar like:
DB_NAME define(‘DB_NAME’, ‘database_name’);
2.Select the database in phpMyAdmin:
Acess your MySQL databse through phpMyAdmin. On the left hand side you can find a column listing all the tables. Look for the name that you found in your wp-config.php and click on that. You will see a list of tables with a prefix wp_ for the most part.
If you would have changed your prefix during installation, then you would be looking for that specific prefix like “wpmike_”.
3.Change the password:
After selecting the database you can see some tables. Select the table wp_users, click on it and then click on the Browse Tab.
Then click the Pencil( for edit) button to edit the password.
Then you can see a tabular field.
Edit the user_pass field value. You will notice that there are a lot of random characters in the password field. Due to security reasons, WordPress stores the passwords as MD5 hash rather than Plain text.
If you liked this article let your friends, colleagues and family know and share it with them. Thank you!