• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

WP Thinker

The WordPress Playground

  • Snippets
  • Best
  • Guides
  • Reviews
Home / Guides

June 5, 2020 Muhammed Swalih

How to Reset WordPress Password from phpMyAdmin

How-to-Reset-WordPress-Password-using-phpMyAdmin

So you forgot your WordPress password, right? But you also don’t have the access to your email address registered with the WordPress account. If you have access to the phpMyAdmin tool that comes with most of the managed web hosting providers such as Siteground or Bluehost, you can easily reset the WordPress password. In this article, we are going to list the complete list of steps that you have to follow to gain access to the WordPress backend by resetting your WordPress profile password using phpMyAdmin.

Reset Password in WordPress using phpMyAdmin

Most of the WordPress managed web hosting providers comes with cPanel or similar dashboard where you can find phpMyAdmin tool.

  1. Open phpMyAdmin.
    phpMyAdmin in cPanel
  2. Click on the database table on the left side.
    Choose Database in phpMyAdmin
  3. Now click on wp_users table on the right side.
  4. Click Edit besides the user you want to reset the password of.
    Edit wp_user Table
  5. Enter your new password in the user_pass field.
    Input New Password in MD5 Format
  6. Chooe MD5 in dropdown menu.
  7. Click Go.

You will get a success message in green color and the password of the user has been successfully edited using phpMyAdmin. Be sure to note down the password somewhere or use a password manager to avoid repeating this over again.

Is it safe to use phpMyAdmin to reset password?

It is safe as long as you do not make any other changes to the database tables. Be extremely careful while playing with the database and edit the correct sections as mentioned in the steps. If you do anything wrong, your site or functionalities may broke. If you are not sure, you can take a database backup from your host before attempting to change password by editing it. phpMyadmin is like a database management tool that allows you to edit your database. That means, you do not necessarily need to use the tool to make changes if your host provides a separate tool that can edit the database tables.

Many hosting provides like Cloudways provide such database management utilities that can edit your database tables without phpMyAdmin. But I would recommend using phpMyAdmin for performing actions related to databases as it will be more stable than the newer tools developed by the hosts.

Avatar for Muhammed Swalih

Muhammed Swalih

A WordPress expert who has been tweaking WordPress functions, plugins, themes and almost everything related to WordPress for the past 5+ years.

Primary Sidebar

Related Articles

Footer

WP Thinker is a website that publishes everything related to WordPress, Plugins, Themes, SEO, Blogging, etc.

  • Facebook
  • Twitter
  • Pinterest

Copyright © 2023 · WP Thinker

  • About Us
  • Advertise
  • Write for Us
  • Privacy Policy
  • Terms and Conditions
  • Contact Us
This website uses cookies to serve you better. By continuing to use this website, you agree to our cookie and Privacy Policy.