Support » Fixing WordPress » Admin access (You do not have sufficient permissions to access this page.)

  • Resolved eightlaces

    (@eightlaces)


    Hey there,

    I was having quite a bit of difficulty with the “You do not have sufficient permissions to access this page.” error to the point where I decided to scrap everything and start from scratch.

    A new installation led to not being able to connect to the database and whole bunch of new problems, so I recovered everything and the nice folks at Dreamhost helped me plug everything in correctly.

    Still, the error persists.

    I decided to go digging in the SQL database and used this article in the hopes that I could give a user admin access this way. Three tries and nothing.

    I attempted to create a brand new user. Nothing.

    Please help.

Viewing 15 replies - 1 through 15 (of 22 total)
  • David Choi

    (@wpthemes777)

    Maybe it’s related to changed table prefixes? Here is what I’ve found:

    eightlaces

    (@eightlaces)

    You’ll have to excuse my ignorance as I’m just getting familiar with SQL.

    Where would I plug these in at?

    Moderator Mark Ratledge

    (@songdogtech)

    Forum Moderator

    @EndlessScroll.com: eightlaces’ issues have nothing to do with changed database table prefixes.

    @eightlaces: What page are you trying to access? Are you sure you are logged in as an admin?

    eightlaces

    (@eightlaces)

    @song

    The standard wp-admin page. As I said, I went in and attempted to give multiple users admin access including a brand new user, but for whatever reason, I couldn’t log in as any of them.

    Moderator Mark Ratledge

    (@songdogtech)

    Forum Moderator

    so I recovered everything and the nice folks at Dreamhost helped me plug everything in correctly

    What exactly did Dreamhost do? Are you using the old problematic database with a “new” install?

    eightlaces

    (@eightlaces)

    Dreamhost plugged in the appropriate database, user/PW data, the basic stuff.

    Technically I am using the old database, but I tried making two others and still encountered the WordPress “can’t establish a connection with the database” error.

    Moderator Mark Ratledge

    (@songdogtech)

    Forum Moderator

    OK, but what is happening now? “Can’t establish a connection with the database” is a completely different animal than “You do not have sufficient permissions to access this page.”

    eightlaces

    (@eightlaces)

    I’m getting the “You do not have sufficient permissions to access this page.” error.

    Mika Epstein

    (@ipstenu-dh)

    eightlaces, the last ticket I see from you here at DH is that you don’t know your WP username and password.

    I used WP CLI to check on your users, and the problem is none of your users have any roles associated with them! Whoops! That would do it.

    I did a little digging in your DB and discovered it’s because of curly quotes!

    a:1:{s:13:”administrator”;b:1;}

    That’s not the same as this:
    a:1:{s:13:"administrator";b:1;}

    I went ahead and manually corrected those for you. Try logging in now?

    eightlaces

    (@eightlaces)

    Oh heavens, you are all my bestest friends!

    Thanks SO much for the help!!!

    Mika Epstein

    (@ipstenu-dh)

    You’re very welcome! 🙂 If you need any more help at DreamHost, just let us know.

    Have a good weekend 🙂

    Can anyone help? I habe the same problem! I can access other areas of my dashboard by extending the string (I.E wp-admin/post) but cannot simply login to my dashboard! My hosts are useless with their support too!

    esmi

    (@esmi)

    Forum Moderator

    I have managed to get a wordpress site ….www.78bishopsgate.co.uk on line. I haven’t been to it for a while and when I type in http://www.78bishopsgate.co.uk/wp-admin it gives me the same standard screen saying I do not have sufficient permissions… as far as I know I have not changed anything, there is only one user…i.e. me and I cannot begin to think what could have happened.

    esmi

    (@esmi)

    Forum Moderator

    Using Phpmyadmin (or another MySQL management tool), first backup your database. Then navigate to your wp_usermeta table and locate the meta_key called “wp_capabilities” for your user_id. Change the meta-value for this record to:

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

Viewing 15 replies - 1 through 15 (of 22 total)
  • The topic ‘Admin access (You do not have sufficient permissions to access this page.)’ is closed to new replies.