After new migration
Log into admin page
It should have gone straight to the dashboard.
Instead, website home page shows with wordpress menu bar across the top with no dashboard option to select.
In Adminer (database tab in Localwp dashboard)
I checked out xx_usermeta and xx_users (xx= table prefix) as I had read on the net a possible fix to this issue is to add a new admin user via the database.
However I noticed that in xx_usermeta for the proper admin that some of the meta_key values that reference other tables had the the table prefix capitalised. Sure enough SQL is case sensitive.
I went through and edited all the appropriate meta_key values returning the table prefix to lower case, saved, and the normal admin now works as it should going straight through to the dashboard.