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

OK thanks – although I am afraid that is rather a foreign language to me… is this possible for a layman to do or do I need professional help?

david4angie, you should probably make your own post, as this is resolved (and you’re on Heart Internet, not DreamHost).

It IS possible for a layman to do it, but ask your host how to access phpMyAdmin if you don’t know how.

Wasn’t me talking about Dreamhost, that was some other chap! Yes after the hugely complicated email from our good friend esmi, a friend of my suggested that I re-set password. What appeared to be happening was WP was trying to use my twitter handle as my user name which was why it wasn’t letting me in…don’t ask me any more as I know not where or how

david4angie, the point was the ORIGINAL poster, eightlaces, WAS asking about DreamHost, and this topic is resolved.

So you’re not going to get anyone ‘new’ helping you in anything that’s resolved, or NOT specific to your problems. Which is why we ask folks, 99% of the time, to make a new topic all for themselves ?? Make sense?

I have the same issue as above “You do not have sufficient permissions to access this page.”

However, the following did not work
a:1:{s:13:”administrator”;s:1:”1″;}

I am pretty sure that I don’t understand this statement… since there are 3 “1”, I assuming one of them corresponds to my admin id, which do I change for the ID of the new current Admin user ID?

NOTE: This happened after I changed the table prefix from wp_ in the database as well as in the wp-config.php file.

NOTE 2: before the change, the field content was
a:1:{s:13:”administrator”;b:1;} <- same as other two admins accounts, which don’t work either.

ALSO TRIED changing the following from another post on the subject
in table “newprefix_options”
option_name “wp_user_roles” to “newprefix_user_roles”

NO GO there either, after every change attempt the browser was cleared of site data.

I think I might have found the Solution, but I want to ask you experts who have experience with this issue.

I found the following at https://www.ads-software.com/support/topic/wp-admin-you-do-not-have-sufficient-permissions-to-access-this-page?replies=12

In your database, using phpMyAdmin, check that the tables all begin with the same prefix that you have in your wp-config.php. For example if you changed your table prefix to “b2”, the tables would be “b2_commentmeta”, b2_comments”, etc.
Also, you have to check inside two tables to see that certain field names are also changed. So, using the same prefix as above, in b2_options, the field wp_user_roles has to be changed to b2_user_roles. And in the b2_usermeta table, the fields wp_capabilities, wp_user_level, wp_user-settings, wp_user-settings-time, and wp_dashboard_quick_press_last_post_id should all have the prefix b2_ instead of wp_.

And lastly, within your database, look at the values in the wp_usermeta table as follows:

wp_capabilities should be a:1:{s:13:”administrator”;s:1:”1″;}

wp_user_level should be 10

AFTER
Doing this, I was able to get back in to the Admin Dashboard. However, my question is, will these changes move forward, for new members, etc. or is this just a band-aide?

I’m closing this thread. eightlaces has been helped.

Everyone else – Make your own topics.

Especially you SoCalCreations – You have a different issue