WordPress: Changing a user password via database

If you lose the password for your WordPress Admin user, you can enter a new one quickly in the database using phpMyAdmin.  After logging in to cPanel, follow these quick steps:

  1. Click phpMyAdmin.
  2. Click the "+" next to your WordPress database.  WordPress databases usually begin with "wp_".
  3. Click "wp_users".
  4. Click "Edit" next to your administrative login.
  5. Enter a new password in the "user_pass" field.
  6. Click the drop-down menu next to your new password and select "MD5" from the list.
  7. Click "Go"
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to make WordPress show as Secure in Google Chrome

In order to make your WordPress installation show as Secure in Google Chrome, you'll need ensure...

Temporary URLs in WordPress

To use your Temporary URL with a WordPress installation, you will need to edit the Windows Hosts...

WordPress Optimization

Optimizing your scripts can keep your server and website loading quickly for your visitors. These...

Changing the WordPress Directory

You may want to change the location of your WordPress blog after you have installed it. For...

Fixing the Internal Server Error in WordPress

There are a few possible causes of the 500 Internal Server Error. It is not always due to...