WordPress Error: You do not have sufficient permissions to access this page.
Last Updated on Friday, 25 May 2012 03:01 Written by Dan Friday, 25 May 2012 03:01
Usually setting up a new WordPress you get the option to create tables with a custom prefix, ie not wp_ But if the database already exists then you need to rename table prefixes manually. On top of which, it can produce an error about not having sufficient permissions when trying to login. This is due to a few options listed within the database.
To avoid a few headaches and searching try:
In wp_usermeta or { prefix }_usermeta
Change the following prefix of wp to { prefix }
wp_capabilities
wp_user_level
wp_dashboard_quick_press_last_post_id
wp_user-settings
wp_user-settings-time
also in wp_options or { prefix }_options
I changed the following prefix of wp to { prefix }
wp_user_roles
Thanks to bhanu2217 here:
