How to fix the “You do not have sufficient permissions to access this page” message in WordPress

Published on September 10, 2009 in WordPress. 24 Comments Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , .

I’ll tell you my story, but you may be in the same situation having done something completely different, so keep reading…

One day, some time ago, I was very happily installing the WP-Security-Scan WordPress plugin, and I got an analysis result saying that I should change the default WordPress database table prefix in order to make harder the potential SQL Injection attacks…

WordpressAuthorization_TablePrefix1

So I went to the link and filled the new prefix in the screen that appeared…

WordpressAuthorization_TablePrefix2

After pressing the “Start Renaming” button, I got the following page:

WordpressAuthorization_TablePrefix3

Everything seemed to have been done perfectly…

But…… This is what I got after trying to go somewhere else in the administration panel:

WordpressAuthorization_Insufficient_EN

The infamous “You do not have sufficient permissions to access this page” message…

From this point on, I could not access the administration panel anymore… So what could I do?

The problem seemed to be generated by the modification of the WordPress table prefix, so I went to phpMyAdmin to check the database… Everething seemed OK.. I checked the wp-config,php… The prefix had been updated… The site seemed to work flawlessly for normal visitors…

So I started searching… And finally found a site whose solution I’ll leave you below in a easier to use way…

Solution

If this problem was generated by a change to the WordPress database table prefix (done by the buggy WP-Security-Scan plugin, by a migration or by other means), you should fill the following two fields and press the “Generate” button to generate a SQL Query which you should execute in your database (using phpMyAdmin or other options)…

Old Prefix
New Prefix
 

SQL

That’s all… If this didn’t work for you, it may be other kind of problem… In that case, take a look at the comments section of this post, since there are some people which found other solutions.

Hope it helps :)

Support appreciated!

All the content offered in this website is, except noted otherwise, of free nature. This means you can share it wherever you want if you do it freely and stating its source.

If it was useful for you and you’d like to contribute, you can make a donation or, at least, visit one of our advertisers of your choice; they are all around the site.

Incoming search terms for the article:

  • Share/Bookmark

Related posts:

  1. How to remove the “Visual” tab from the WordPress post/page editor
  2. Google (XML) Sitemaps Generator with qTranslate support now available at the WordPress Repository
  3. Updated: qTranslate support for the Google (XML) Sitemaps Generator WordPress Plugin 3.1.6 (2nd Release)
  4. Hide WordPress Visual Editor Tab 1.01
  5. Important Update: Google (XML) Sitemaps Generator with qTranslate support (Version 3.1.6.3)



24 Responses to “How to fix the “You do not have sufficient permissions to access this page” message in WordPress”

Feed for this Entry Trackback Address

Leave a Reply