for dynamic development, it is best to have a local testing server rather than connect to the remote MySQL server.
see the learning resources page:
resources.php
there are tutorial there for setting up a testing server, setting up a Dreamweaver site for dynamic development and creating the database connection that should address your questions.