Copied WP Install redirects admin to user

Did you also changed the prefixes on wp_options and wp_usermeta tables?

Hi David,

I have changed nothing in wp-usermeta. which values should I look at?
Currently I have:
show_admin_bar_front true
wp_capabilities a:1:{s:13:”administrator”;b:1;}
wp_user_level 10

wp-options I have updated from aaa to bbb.

I have changed wp_capabilities to wpbbb_capabilities and wp_user_level to wpbbb_user_level

still not logged in as admin…

And did you check all rows that have wp_* on it?

You can list them with a query like:
SELECT * FROMwpbbb_usermetaWHEREmeta_keyLIKE '%wp_%'
or on options:
SELECT * FROMwpbbb_optionsWHEREoption_nameLIKE '%wp_%'

You can also create a new user directly on database with admin access and use that user to reset your user back to administrator.

You can check here the quickest way to do it with 3 sql queries:
https://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/

In wpbbb_options there was an entry called wp_user_roles. I renamed it to wpbbb_user_roles and now it worked. So David, thank you a lot. Very helpful.