You will need to change the connection details manually each time.
for the error message, did you export the data from the local MySQL Database and import it to the remote database?
Using a mysql gui tool like PHPMyAdmin, you will need to export the local PowerCMS Database and import it to the remote database.