Skip to main content

WordPress Admin Recovery

wordpress admin recovery webnestify

Have you ever found yourself locked out of your WordPress admin panel, desperately searching for a way to regain control of your website? Well, fear not, because in this tutorial, we're going to show you a powerful solution.

Loosing your WordPress admin password can be a stressful situation, but with the help of phpMyAdmin, you can create a new wp-admin account and get back in the driver's seat of your website. Whether you've forgotten your password or simply can't access your WordPress admin panel for some reason, this step-by-step guide will walk you through the process of resetting your admin credentials safely and effectively.

Prerequisites

In order to perform recovery, you need to have your phpMyAdmin app installed alongside your web applications. Consult your hosting provider or your web management stack.

Here is an example how you can deploy it in Runcloud. phpma-rc.png

Password Reset

In some cases, you just need to reset your password when you don't receiving emails from your WordPress.

Get your database credentials from wp-config.php file.

  1. Log in into your phpMyAdmin instance.
  2. Select your database.
  3. Navigate to wp_users table.

If your database prefix have been changed, replace wp_ with your custom prefix!

  1. Select your desired user.
  2. Edit user_pass field with your new password and select from dropdown MD5.
  3. Click Go.

password-reset.gif

Create Admin User

If password reset procedure does not help or for whatever reason you are not able to log in, follow this step by step to add new Wordpress admin.

  1. Log in into your phpMyAdmin instance.
  2. Select your database.
  3. Navigate to wp_users table.

If your database prefix have been changed, replace wp_ with your custom prefix!

  1. Click Insert.
  2. Add required new user data as follows:
    ID — Enter any available ID number. Make sure to remember or save ID for later. If your ID is already in use, choose different one
    user_login — The username for this user.
    user_pass — The raw password the user will login with.Select MD5 from dropdown.
    user_nicename — The author slug or name.
    user_email — The email address associated with this user.
    user_status — Insert 0.
    display_name — The display name for the user.
  3. Click Go.
  4. Click Go again.
  5. Select wp_usermeta table.
  6. Click Insert again.
  7. Add required field as follows:
    user_id — Same ID from Step 5
    meta_key – wp_capabilities
    meta_value — a:1:{s:13:"administrator";b:1;}
  8. Click Go at the bottom and on the query.
  9. Click Insert for the last time and add following:
    user_id – Same ID from step 5
    meta_key – wp_user_level
    meta_value – 10
  10. Click Go.

new-admin.gif

Now you should have access to your Wordpress via admin that you just created.

About Webnestify

Imagine a world where you can focus on your business and less time maintaining your cloud infrastrucure. With Webnestify cloud based solutions, we provide customized solutions for all types of companies to meet their needs; no matter how big or small they may be!

Read our reviews on Trustpilot!

Subscribe to our YouTube channel!

If you need to setup your own Docker instances or need help with security, visit our contact page.

Back to top