Cannot login even after DB password reset

  • Resolved egoplacebo

    (@egoplacebo)


    9 months, 1 week ago

    The site has 2 (admin) users, neither of which are able to login. It claims password is incorrect. I have reset password in phpmyadmin using MD5 but still cannot login.

    I also tried several sites that supposedly create a password hashed in the normal WP method, which did not work either.

    I enabled the debug log, but nothing is being written to it. There is nothing relevant in PHP or apache logs either.

    I am running out of ideas, anyone else have any?

    Is there some way to reset the logins as if its a fresh install, but without losing any data etc. on the site?

    Active-plugins: a:4:{i:0;s:41:”classic-menu-block/classic-menu-block.php”;i:1;s:35:”product-specifications/wc-specs.php”;i:2;s:27:”woocommerce/woocommerce.php”;i:3;s:38:”yith-woocommerce-catalog-mode/init.php”;}

    • This topic was modified 9 months, 1 week ago by egoplacebo.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter egoplacebo

    (@egoplacebo)

    More info:
    Other WP sites on the same server are logging in fine.
    Tried different browsers, clearing cache, disabling plugins via database.
    Email is not configured so email password reset not available.
    Front of site seems fine, so db access must be OK (also checked config).

    Alor Web

    (@jerrymayalor555)

    Hi @egoplacebo,

    Since you have access to the database of your website. You can try the following:

    • Go to the wp_options table.
    • Find the column for option_name.
    • Scroll down until you find the admin_email.
    • Insert your active email on the option_value column just right beside it.
    • The email will receive the password reset. Make sure that you have access to that email.
    • Now go to the login page of your website. https://yourdmain.com/wp-admin.
    • Click the Lost Password link.
    • Enter the email that you have added on your database.
    • Click Get New Password.
    • Now try to login using your email and new password.

    Note: make sure to store your email and new password somewhere safe for future reference. You can’t forever memorized it.
    Please try the recommended solution and let me know how it goes.

    Regards,

    Thread Starter egoplacebo

    (@egoplacebo)

    Thanks @jerrymayalor555

    The admin email was already set, but I hadn’t realised it was going to the junk folder. Still after finding it the password reset didn’t work at first, but after a couple of tries, it finally let me in, so I’m not sure what was going on there!

    Alor Web

    (@jerrymayalor555)

    Just try to add filters to your email account. There are articles available on the internet on how to manage filters in your emails, and you can organize them. 

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Cannot login even after DB password reset’ is closed to new replies.

Tags