Godaddy After ‘Push staging to production’ I can’t access my WP Admin on the live site anymore

After ‘Push staging to production’ I can’t access my WP Admin on the live site anymore. It’s showing “Sorry, you are not allowed to access this page.”

Solutions:

Check the wp_options table and look for (in your example) wp_XXXXX_user_roles – it’s in the ‘option_name’ column, and change it to wp_user_roles.

Next

Goto “wp_usermeta” table and search for “wp_XXXXX_capabilities” & “wp_XXXXX_user_level”
and replace that with your Prod table prefix “wp_capabilities” & “wp_user_level”