Migrated site comes up as fresh install

Following along the vid for migrating a locally built wordpress to a live server (using cPanel, not dream host) and I have followed everything but when I go to my site, it wants me to install wordpress and create a user (several steps that are usually there during installation are missing and all I have to do is type in a site name and user). I have re-uploaded, re-uploaded my database, re-exported, re-done basically everything, but I still cannot get it to work.

I am migrating it to the root of my website, and the only thing I can see as different to the vid is that my host (web hosting hub) requires me to prepend my DB name and DB user with my hosting username 'user_'

When I log in to the wordpress theme after installation, I can access the theme I built and activate it but no plug-ins (custom post, custom pages etc) show up. It looks like wordpress isn't accessing my plug ins, but I have checked my ftp on the server and they are all there.

I also tried activating each of the plug ins, then used find and replace to replace all localhost/siteurl to just siteurl (since I was installing it in the root) and this still did not restore it.

Have tried to give as much information as possible, any help would be great