Thank you for your response @akshat007
I’ve checked and confirm the prefix, user capabilities attribute and config.php as you instructed and they were all correct.
But the issue still remains.
I have even replaced all the files and folders (except wp-content and config.php) from a new WordPress download, yet the issue remains.
I just want back the admin dashboard access to export our posts, pages, media to our new hosting provider.
Or is there another way I can do that?
(Our database is bloated (over 11gb) tried reducing but didn’t work so we just want to move out the posts (1,200+), pages, and media to a new database)