One fine morning you wake up, check your site and see that your site has been hacked or anything, you immediately want to change your password but then you notice that you are unable to login the admin panel of your site through the login, moreover you are not even able to reset your site’s password through e-mail. At this moment, you might lose your nerve for a while but no need to worry, we have a solution to it now.
In such situations, phpMyAdmin might help you in overcoming from such problems. All WordPress blogs are accessed through a database and every database can be controlled and managed by phpMyAdmin. Hence, just by accessing phpMyAdmin we can easily change the WordPress password.
You can follow the below mentioned steps for assistance:
- Find out the name of the Database: Your WordPress Directory comprises of a file named wp-config.php. This file includes the name of the database where the WordPress has been installed. With a similar line like the one mentioned below, you can find the database name:
DB_NAME define(‘DB_NAME’, ‘database_name’);
- Select the Database in phpMyAdmin: You can enter your MySQL database with the help of phpMyAdmin. After entering the database, on the left hand side you would see a column showing the tables, here you would have to look for the name that you found in your wp-config.php and click on that name. You would then see a list of tables with a prefix wp_ for the most part.
If during the installation phase you would have changed your prefix, then you would have been looking for a specific prefix such as “wpmike_”.
- Reset/Change the password: After selecting the Database, you would see some tables. Select the wp_users table, click it and then press the browser tab.
After this, you need to click on the edit button ( pencil icon) to change the password.
Then, you would be able to see a tabular field.
The next step you need to do is edit the user_pass field value. Because of some security reasons, WordPress puts the passwords MD5 hash instead of plain text. Hence, you would see a lot of random characters in the password field.