2012 - 2023 Eleven Years of Excellence

Change Your WordPress Password in the Database

Facebook
Twitter
LinkedIn
Change Your WordPress Password in the Database

Usually, you can change Your WordPress Password in the control panel or request a new one by email. If you don’t have access to both your email and WordPress dashboard, you can change your password directly in the database.

Why Reset WordPress Password from phpMyAdmin?

WordPress makes recovering a lost password very easy. You can go to the login screen of your WordPress website and click on the ‘Lost your password?’ link.

Change Your WordPress Password in the Database

When you click on the link you will be taken to the password reset page. After you enter your username or email address, WordPress will send a password reset link to the corresponding email address.

However, if you don’t have access to that email address, or your WordPress site fails to send an email, then you won’t 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 to use phpMyAdmin.

How to Change WordPress Password from PhpMyAdmin Database

  1. First, you need to login into the cPanel dashboard of your WordPress hosting account.
  2. Next, you need to navigate to the Databases section where you can click on the phpMyAdmin icon.
  1. Now, select your WordPress database and you will see the list of tables in your WordPress database. You should search for the wp_users table in this list and click the Browse link next to it.
  1. You will now see rows in your WordPress users table. Click the Edit button next to the username you wish to change the password for.

Note: Table names in your WordPress database may have a different prefix than the one we show in our screenshot. Changing table prefixes can improve the security of your WordPress site.

  1. Select MD5 from the drop-down menu under Function next to user_pass.
  2. Under Value replace the current encrypted password with the new password. You can type in plain text, which will be encrypted after saving.
  3. Click Go to save your changes.
  1. Your new password is saved and encrypted. It can now be used to login into WordPress.
Editor

Editor

Leave a Replay

Sign up for our Newsletter

Agency Hosting - Singapore Datacenter ( SSD )
Select your billing cycle
1 Year

LKR 12,000/-

You save: LKR 3,000.00

Renew at LKR 15,000.00/Y

2 Years

LKR 24,000/-

You save: LKR 6,000.00

Renew at LKR 15,000.00/Y

3 Years

LKR 36,000/-

You save: LKR 9,000.00

Renew at LKR 15,000.00/Y

If you’re not 100% satisfied with LankaHostMaster, we’ll refund your payment. No hassle, no risk.
Premium Hosting - Singapore Datacenter ( SSD )
Select your billing cycle
1 Year

LKR 10,800/-

You save: LKR 1,200.00

Renew at LKR 12,000.00/Y

2 Year

LKR 21,600/-

You save: LKR 2,400.00

Renew at LKR 12,000.00/Y

3 Year

LKR 32,400/-

You save: LKR 3,600.00

Renew at LKR 12,000.00/Y

If you’re not 100% satisfied with LankaHostMaster, we’ll refund your payment. No hassle, no risk.
Single Hosting - Singapore Datacenter ( SSD )
Select your billing cycle
1 Year

LKR 7,200/-

You save: LKR 800.00

Renew at LKR 8,000.00/Y

2 Years

LKR 14,400/-

You save: LKR 1,600.00

Renew at LKR 8,000.00/Y

3 Years

LKR 21,600/-

You save: LKR 2,400.00

Renew at LKR 8,000.00/Y

If you’re not 100% satisfied with LankaHostMaster, we’ll refund your payment. No hassle, no risk.
Agency Hosting - Germany Datacenter ( NVMe )
Select your billing cycle
1 Year

LKR 12,000/-

You save: LKR 3,000.00

Renew at LKR 15,000.00/Y

2 Years

LKR 24,000/-

You save: LKR 6,000.00

Renew at LKR 15,000.00/Y

3 Years

LKR 36,000/-

You save: LKR 9,000.00

Renew at LKR 15,000.00/Y

If you’re not 100% satisfied with LankaHostMaster, we’ll refund your payment. No hassle, no risk.
Premium Hosting - Germany Datacenter ( NVMe )
Select your billing cycle
1 Year

LKR 10,800/-

You save: LKR 1,200.00

Renew at LKR 12,000.00/Y

2 Year

LKR 21,600/-

You save: LKR 2,400.00

Renew at LKR 12,000.00/Y

3 Year

LKR 32,400/-

You save: LKR 3,600.00

Renew at LKR 12,000.00/Y

If you’re not 100% satisfied with LankaHostMaster, we’ll refund your payment. No hassle, no risk.
Single Hosting - Germany Datacenter ( NVMe )
Select your billing cycle
1 Year

LKR 7,200/-

You save: LKR 800.00

Renew at LKR 8,000.00/Y

2 Years

LKR 14,400/-

You save: LKR 1,600.00

Renew at LKR 8,000.00/Y

3 Years

LKR 21,600/-

You save: LKR 2,400.00

Renew at LKR 8,000.00/Y

If you’re not 100% satisfied with LankaHostMaster, we’ll refund your payment. No hassle, no risk.

What is NVMe

NVMe can deliver a sustained read-write speed of 2000MB per second, way faster than the SATA SSD III, which limits at 600MB per second.

NVMe can deliver a sustained read-write speed of 2000MB per second