Upon creating a new site (from a zip file), I was not able to access the dashboard even though I was using an Admin account. Sharing here so no one else spends a stupid amount of time on this issue only to arrive at an embarrassing conclusion.
Deactivated all plugins through the database. Checked role via database. Finally, edited a core file to show me what Wordpress was reading as my role. It was nothing. I had no role. Wordpress couldn’t determine my role because the roles and levels records in the usermeta table had case issues! Example: database prefix is “abcde”; meta_name in usermeta table was aBcDe_user_roles and aBcDe_user_level. My table prefix is not actually abcde, it’s something that made the case issue much less obvious. I have no idea how the live site works with the case being messed up or how it got that way (the site was years old before I started managing it). But hopefully this helps someone.
Operating System (OS) and OS version:
Attach your Local Logs here (Help Doc - Retrieving Local’s Log)
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.