change usergroup via phpmyadmin

  • Hi,

    my server had some upgrades and for some reason the result messed up some of the login accounts. mostly couldn’t login, just displays 502 Bad Gateway. I have 2 accounts created for myself, 1 is the admin and the other has a normal user priviledges. I have no problem loggin in using normal user account but not as admin. I have access to phpmyadmin and i want to change this user’s privileges to admin so i can have access to the admin settings again. is there a way to do this via phpmyadmin?

    thanks

Viewing 2 replies - 1 through 2 (of 2 total)

  • sure
    browse the wp_usermeta table
    scroll down to the wp_capabilities meta key (user id will be “1”)
    click on pencil icon to edit
    in the text box enter
    a:1:{s:13:"administrator";s:1:"1";}
    and save

    Thread Starter nashsaint

    (@nashsaint)

    Thanks for the quick reply. I tried this wih the normal user and i got a 502 bad gateway. I am able to login when i changed it to normal though. I was able to try this in one of other users, a friend, and it shows same 502 error. It seems that the error only happens to users with admin priviledges. Is there a fix to this from wordpress related script or it has to do wih my server? I hve contacted them though and they said all should be fine.

    Thanks for your help.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘change usergroup via phpmyadmin’ is closed to new replies.