Decided to dig even deeper, since this was annoying me.
made a new website a clone then used beyond compare to see differences.
on page 9 on wp_options >> – option_name
there is a well hidden cell called “wp_user_roles”
IF you cannot find this search in phpmyadmin for “user_roles”
this is where the last field was that needed to be changed from nae_ to wp_
You can now log back in!! i hope this reference helps people.
so make sure once you change the following
wp_usermeta
nae_capabilities to wp_capabilities
nae_user_level to wp_user_level
nae_user-settings to wp_user_settings
nae_user-settings-time to wp_user-settings-time
You must also change it in the well hidden 9 page
wp_options >> user_roles
