»  Knowledgebase  »  WordPress Administration  »  Gain access to a locked WordPress website

Gain access to a locked WordPress website

by | Jun 22, 2022 | 0 comments

If you are locked out of your website and a password reset hasn’t worked (eg, emails may not be working or you may no longer have access to your email address), you can still gain access to your WordPress dashboard if you have access to your webhosting account and a database management tool. In this tutorial we are using phpmyadmin which is bundled with many popular webhost control panels.

Proceed with caution! One slip may damage your website beyond repair!

Login to your webhosting account

How you login to your webhosting account will depend on your webhost.

Identify your WordPress database

In your filemanager, this information is stored in the file {website root}/wp-config.php

Locate and Open phpmyadmin

In this screen shot we are using cPanel.

Navigate to the users table in your Database

  • Open your database by selecting it in the left hand panel
  • Users are stored in the table wp_users - although wp_ may be replaced with a random prefix, in this example wpow_
  • Edit Admin user

  • Identify your admin user and select Edit
  • Change user password

  • Change user_pass function to MD5. This is the password encryption type
  • Enter new password into the user_pass value field
  • Hit Go
  • The new password will be saved in the encrypted form

    Login to Dashboard

    You can now login to the WordPress dashboard using the admin username with the new password you have set in the database.


    Submit a Comment

    Your email address will not be published.

    UK WordPress Support

    We are a team of UK based WordPress experts offering WordPress help & support, WordPress site management and maintenance, content management services, one to one WordPress training and consultancy.

    Need to chat? Contact Us Now!

    WordPress Maintenance

    Let us manage your plugin and theme updates, keep your WordPress website site running smoothly and your visitors happy!

    WordPress Care Plans
    from just £35 / month!

    One to One WordPress Training

    We provide one to one WordPress training to individuals and companies all over the World!

    Whether you are developing new skills for business or working on a personal project, we can support you, and your first trial session is free!

    Book an initial WordPress Orientation Session

    Get the WordPress Management Guide

    Get the WordPress Management Guide

    Sign up to our newsletter to receive our insider guide to managing WordPress in [currentyear], free to your inbox.

    You have Successfully Subscribed!