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)
  • Maybe it’s related to changed table prefixes? Here is what I’ve found:

    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?

    @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?

    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.”

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

    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?

    Oh heavens, you are all my bestest friends!

    Thanks SO much for the help!!!

    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.