Admin access (You do not have sufficient permissions to access this page.)

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?

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

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.

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!

@leepallister: As per the Forum Welcome, please post your own topic.

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 https://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.

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";}