@mitzelaki This is definetelly due to database connection. Your steps are correct to change DB detail into local.xml file, before that on your migrated server have you create new Database and assign user to that newly created Database ? Do make sure you have give all privileges to newly created DB.
Yes you also need to change URL into core_config_data table.
Hello!Thank you for your response..yes I have a new role and pass to my new database...as for the privileges what do you mean?can i assign them from phpmyadmin or somewhere in magento (I am front-end dev so with this stuff I dont have a lot of exp)
thank you in advance!
@mitzelaki You can assign privileges from Cpanel Or SSH to database user.