Home » Wordpress » WordPress Fix “You do not have sufficient permissions to access this page”

WordPress Fix “You do not have sufficient permissions to access this page”

Fix for WordPress “You Do Not Have Sufficient Permissions to Access This Page”

wordpress-error

So you’ve created a local installation of your WordPress site. Now you have the WordPress “You do not have sufficient permissions to access this page” error.  Over and over no matter what you try. UGH!

There are dozens of blog posts with excellent solutions to this problem. But if you’ve been at WordPress for any length of time, you’ve probably discovered that  many of the hacks and tweaks that work for others just don’t fix your problem. It’s happened to me, too few days back. It is a weird situation when the admin itself is not allowed to access WordPress Admin Panel.

you-do-not-have-sufficient-permission-to-access-this-page

I tried many ways but still I got the error. But no matter what I did, I kept getting the dreaded WordPress “You do not have sufficient permissions to access this page.” I knew it was a database permissions problem, but I just couldn’t get the right combinations of tweaks to work. The problem turned out to be incomplete WordPress admin user data because of corrupt tables.

I finally came up with the manual procedure that fixed my particular problem. Those troubleshooting steps are listed

But first, you might want to try using a different browser. A reader recently posted that he was getting this error with Firefox but was able to access his site using a different browser. Browser caching can definitely cause problems like this, so it’s a great tip to try first.

This error occurs if you moved your site or changed your WordPress table prefix

If that doesn’t help, enter the following SQL commands in your PHPmyAdmin to get back your access

UPDATE `wp_usermeta` SET `meta_key` = replace(`meta_key`, 'wp_test_', 'wp_');
UPDATE `wp_options` SET `option_name` = replace(`option_name`, 'wp_test_', 'wp_');

 

here the wp_test_ is your old WordPress table Prefix  and wp_ is your new WordPress Prefix.

 

Feel free to say thanks by dropping a comment below

,

One thought on “WordPress Fix “You do not have sufficient permissions to access this page”

  1. jim mccann says:

    I have a site that allows some plugins to load in admin. However when I try to run “Regen Thumbnails” I get this error.

    I’ve disabled all Plugins, used default the Default theme, changed database entries and yet I still get get rid of this error.

    Does anyone know why it just happens and appears near impossible to fix.?

Comments are closed.