When you upload Power CMS to the server, you will need to edit the connection file to use the proper credentials for connecting to the remote database.
You will also need to export the database from your local testing server and import it to the remote server using PHPMyAdmin.