2FA won’t activate, but says it did

  • Resolved kevindj71

    (@kevindj71)


    1 year, 10 months ago

    I’ve done a couple of clean installs of Wordfence and I still cannot activate 2FA for my admin account. I get no errors in the process and when I type in the authenticator code, it says it’s active. However, I go back to the Users page and it still says Inactive and there is no prompt at login to enter a code. I do get errors on the diagnostics page, but I’ve done clean installs with removing all data and tables so it can rebuild everything. I have just submitted the diagnostics report to [email protected].

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

    (@kevindj71)

    Disregard, I’ve resolved this on my own. I reviewed the diagnostic dump file and noticed there were some MySQL user permission issues. I updated the user and reinstalled, and was able to activate my 2FA.

    Hi @kevindj71 – that sounds like my issue exactly…

    Can I please ask what MySQL issues you found and what you did to fix them.

    Many thanks

    Thread Starter kevindj71

    (@kevindj71)

    Hey @jason-kickmouth – in my case I went to Wordfence>Tools>Diagnostics and clicked the Export button. Those logs stated my database user didn’t have four required privileges. You should also see see some similar errors on the Diagnostics page about missing tables. Upon performing my third clean install, everything’s working great.

    | Checking if MySQL user has CREATE TABLE privilege | FAIL |
    | Checking if MySQL user has ALTER TABLE privilege | FAIL |
    | Checking if MySQL user has DROP privilege | FAIL |
    | Checking if MySQL user has TRUNCATE privilege | FAIL |

    Thread Starter kevindj71

    (@kevindj71)

    @jason-kickmouth – the fix was obviously to go to my host and grant the missing privileges for the db user and perform another clean install in order to rebuild everything.

    • This reply was modified 1 year, 10 months ago by kevindj71.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘2FA won’t activate, but says it did’ is closed to new replies.