Your website is hacked and you find out that can’t log in anymore, and even worse, when you use the “lost password” feature to reset your password, you don’t receive any emails.
You wish to recover or change your WordPress password from PHPMyAdmin?
If your website is infected by malware, then we recommend that you take a look at this article, it will show you how to clean your WordPress site from malware.
In this tutorial, we will show you how to change your WordPress password and email directly from the database (PHPMyAdmin).
- 1) Method 1: Change WordPress password from PHPMyAdmin
- 2) Method 2: Change using SQL query
- 3) Method 3: Change password using FTP
Method 1: Change WordPress password from PHPMyAdmin
Step 1: Access Phpmyadmin (database)
First and foremost, in order to access your database you need to access your hosting panel. If you are using cPanel go to the “Databases” section and click on phpMyAdmin.
Step 2: Backup your Database
Before we change anything into the database, let’s make sure to create a backup.
On the top, just click on Export and select the database name and then press the Go button to download your SQL file.
Step 3: Get your MySQL credentials (optional)
Have your MySQL credentials close by can be very useful, mainly for two reasons:
- If you have multiple databases (multiple sites), and you don’t know which one belongs to your website.
- In some particular cases with a few hosting providers, they require you enter your login credentials in order for you to login to phpMyAdmin.
So to get what we need, in your cPanel dashboard, go to your File Manager and inside the folder of your website open the file wp-config.php and within the first line you’ll find something like this:
The first line is equivalent to your database name, and that’s one where you will need to change the WordPress access information to login.
Step 4: Edit your database
On the left you’ll find a list of your database’s tables. The one we need is “wp-users”, so click on it.
Step 5: Change your Password
Next, you should be seeing on the right your user account, click on Edit.
Now you can add your new password in the marked field while making sure to select MD5 as an encryption function.
Step 6: Change your Email
Make sure you have the right email in the field above, if not, then you should change it as well.
Method 2: Change using SQL query
For this alternative, follow the first 4 steps and then add the following line of code inside the “SQL” tab.
Replace the bold texts with your new user information.
Then press on Go.
Method 3: Change password using FTP
Another way to change your WordPress password, is to go into your File Manager, once you’re inside, go to your theme’s folder and open the functions.php file to add the following line code after this tag <?php
After you add the above code, refresh your login page, and that should do the trick to edit your password, and in this case, the new password will be zzzzzz
After you refresh the page, make sure to remove the code you just added to functions.php otherwise, the password will keep getting reset each time you make a page request.
Lastly, once you log in, do not forget to change your password to a more secure one from your dashboard.
You did it!! Nice work. Now you’ve put yourself back on track and you can now login to your WordPress dashboard.
If for some reason you still can’t access your dashboard after applying these changes, it is highly likely that your site has been infected.
In that case, it’s crucial that you take action by going through the article we recommended at the beginning of this tutorial, it will guide you step by step on how to clean your websites from malware hack.