In this case, you will need a local testing server with PHP and MySQL set up on your loacl computer for testing.
Create the database on the your local MySQL server to develop using using Dreamweaver and DataAssist.
When you upload the files to the remote server, you will only need to update the connection file settings so that it will use the copy of the database on the remote mySQL server instead.
See our learning resources page:
resources.php
for tutorial on setting up a local testing server and configuring a dynamic site in Dreamweaver.