Website

Reset C-Pannel FTP and Wordpress Password

Do you want to reset your WordPress password using phpMyAdmin? If you are unable to reset your WordPress password, then there is a way to reset it directly in your WordPress database using phpMyAdmin. In this article, we will show you how to easily reset a WordPress password from phpMyAdmin.

Why Reset WordPress Password from phpMyAdmin

WordPress makes it super easy to reset your password. You can simply go to the login screen and click on the ‘Lost your password’ link.

Clicking on it takes you to password reset page where you can enter your username or email address to reset the password. After that WordPress sends a password reset link to the email address associated with that user account. For more details see our guide on how to recover a lost password in WordPress.

However, if you don’t have access to the email address, or your WordPress site fails to send an email, then you will not be able to reset your password.

In such a situation, you will need to reset your WordPress password directly in the database. The easiest way to do that is by using phpMyAdmin.

Having said that, let’s see how you can easily reset a WordPress password from phpMyAdmin.

How to Reset WordPress Password From PhpMyAdmin

If you don’t want to watch the video tutorial, then you can continue reading the text version below:

First you need to login to the cPanel dashboard of your WordPress hosting account. Next, you need to click on the phpMyAdmin icon under the database section.

This will launch the phpMyAdmin app where you need to select your WordPress database.

You will now see the list of tables in your WordPress database. Now you need to look for the ‘{table-prefix}_users’ table in this list and click on the ‘Browse’ link next to it.

Note: Table names in your WordPress database may have a different table prefix than the one we are showing in our screenshot.

You will now see the rows in your WordPress users table. Go ahead and click on the edit button next to the username where you want to change the password.

PhpMyAdmin will show you a form with all the user information fields.

You will need to delete the value in the user_pass field and replace it with your new password. Under the function column, select MD5 from the drop down menu and click on the Go button.

Your password will be encrypted using the MD5 hash and then it will be stored in the database.

Congratulations! You have successfully changed your WordPress password using phpMyAdmin.

Now some of you may be wondering why did we select the MD5 hash to encrypt the password.

In the older version, WordPress used MD5 hash to encrypt passwords. Since WordPress 2.5, it started using stronger encryption technologies. However, WordPress still recognizes MD5 to provide backward compatibility.

As soon as you login using a password string stored as a MD5 hash, WordPress recognizes it and changes it using the newer encryption algorithms.

How can I reset my cPanel password?

Using Password reset option
Using Password & Security menu

First of all, keep in mind that you have an opportunity to log in your Hosting account directly from the Namecheap. Thus, you don’t need to remember your cPanel login details, it’s enough to remember only one set of login details – Namecheap account credentials.
So, if you forgot your cPanel password, or the one provided in the welcome email does not work, you can simply log into cPanel via your Namecheap Account Panel.

If you would like to log in through cPanel login page, you can reset the password following these steps:
1. Click Reset Password on the main cPanel login page:

2. Enter your cPanel username and click on Reset password:

3. On the next page, enter your contact email address and click on the Send Security Code button:

4. Once done, the email with the confirmation code will be sent to the contact email address assigned to your hosting account. It is better not to close password reset page as you may need to enter a confirmation code on it.
Below you can see the example of the email:

5. Go back to cPanel page, enter the security code and hit Submit:

6. Once done, the window with the new password appears, use it to log into your cPanel account.

NOTE: If you do not receive the email within 10-15 minutes, feel free to contact us via Helpdesk so that we can assist you with the password change.

If you know your current password, you can change it in your cPanel >> Preferences section >> Password & Security menu:

Fill in the required fields with the Old and the New password you wish to use and hit Change Password:

Setting a New Password for your MySQL User

To set a new password for a MySQL database user:

  1. Log into cPanel and click MySQL Databases in the Databases section:

  2. In the Current Users section, click Set Password next to the desired database user:


     Note: If you are making changes to a website and do not know which user to edit, you may view the user the site is connecting with in its configuration file:
    • Location of Script Configuration Files
  3. Enter a new password, re-enter the password, then click the Change Password button:


     Note: You may use the generate password button to randomly generate a secure password.


Re-Configuring Your Code

If you needed to reset the password to fix a website installation, the site’s configuration file needs to be updated. Once the configuration file has been updated to reflect the new password, the site should work as it was prior.

If you are unsure of where your configuration file is, the following article will help you locate the file you need to edit the database password within:

  • Location of Script Configuration Files

How to Reset your FTP Password

If you are having trouble connecting to your hosting account via FTP, reset your password in the FTP Manager.

Access the FTP Manager

To begin, you will need to login to your Bluehost account.

Bluerock

  1. Click the Advanced tab from the side navigation to the left of the account.
  2. Choose FTP from the sub-menu, or click the FTP Accounts icon from the Files section. Either will bring you to the FTP Accounts page.

Legacy

  1. Click the Hosting tab from the navigation menu at the top of the screen.
  2. Choose FTP Manager from the files section.

Resetting FTP Password

Once logged into the FTP Manager:

  1. Scroll down to FTP Accounts, and find the account that needs to be updated.
  2. Click Change Password.
  3. Enter a new password and click the Change Password button.Make sure passwords match and meet strength requirements to ensure the update completes.

When you have successfully reset your FTP Password, attempt your FTP connection again. If you continue to have problems, see FTP – Uploading the website to make sure your settings are correct.

That’s it!

We hope this article helped you learn how to reset a WordPress password from phpMyAdmin, c-pannel password ,database password and ftp password reset .

We will discuss about How to Remove Malware from WordPress Using a Plugin in our next article.

Tags

Related Articles

Leave a Reply

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

Check Also
Close
Back to top button
Close
Close