If you migrate between a database from Windows to Linux or between different versions in which the destination is case sensitive...
In addition to changing the prefix (the export is usually in lower case from phpmyadmin) you must access the database and adapt all the fields in the _usermeta table.
Once you can log in, use a plugin to perform a prefix change on the entire restored database.
If this does not work, some plugins can insert table names into their configuration, the easiest option is to perform a dump/export, modify the text by searching with Notepad++ or similar, replace the references and re-import the database.
wp-options
table in database and check yoursiteurl
andhome
links are right OR not? – Eliza