the use of dynamic connections is to change which mysql server is being used based on the domain.
what you are asking about can be done with a standard Dreamweaver connection assuming that MySQL Server on domain1 allows for connections from an outside source.
you should contact you host to see if it is possible for the domain1.com mysql server to be connected to from domain2.com