New to the community? Start here

[Defender Pro] Lost admin privileges after changing ID user #1 to something else

Hi,
To increase a little more the security level of my websites, I’ve changed the ID user #1 to another number, then deleted the user #1.
Problem is I lost admin access.
Had a look at phpMyAdmin but looks OK to me.
Any idea?
It happened on the 2 websites hosted in WPMUdev that I dit it on (see for example https://acouphene.eu/) but the same thing worked perfectly as expected for all my other websites which are on my dedicated server.
Best Regards

Thu, 5 Dec 2019 14:40:45
More Defender Pro discussions
Defender Pro
  • Kasia Swiderska
    • Support nomad

    Hello Arom77 ,

    I’m sorry about this issue.

    Had a look at phpMyAdmin but looks OK to me.

    I have checked PhpMyAdmin for the site you mentioned and there are two users there, one of them doesn’t have any capabilities. It is user number 8 then capabilities are empty for that user.
    You would need to edit the field wp_c4_capabilities and put:

    a:1:{s:13:"administrator";s:1:"1";}

    in the table wp_c4_usermeta.

    Just to be on the same page – that site was migrated and had a user with ID 1 and then you changed the ID. How exactly you changed the user ID? Directly in the Database?

    kind regards,
    Kasia