Create Administrator Account via MySQL

  • Resolved willywonka123

    (@willywonka123)


    10 years, 1 month ago

    Hi guys. I’m attempting to perform SQL queries to create an administrator account but am running into issues. I have a single query that executes everything needed, but it seems to not want to work anymore. I’m wondering if there were any changes made in WordPress 4.x that would affect this. My query is:

    https://pastebin.com/raw.php?i=vGiDDaxV

    Can anyone see anything wrong with that query? I’ve made sure i’m using the right backticks and not the “fancy” quotation marks. Basically it creates a user and I can log in, but when I log in, it says “You do not have sufficient permissions to access this page”. Any help would be awesome!

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

  • When logged in from another admin account, what “role” do you see this user has?

    Try changing the user role to something else, and then assign “administrator” privileges to that user and see if that helps.

    If it does, just use phpmyadmin to view the difference in the user tables and the queries that you ran.

    Thread Starter willywonka123

    (@willywonka123)

    They were using their own table prefixes, doh! Thanks for the tip Rajesh ??

    You’re welcome. Glad I could be of help.

    Cheers!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Create Administrator Account via MySQL’ is closed to new replies.