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