In order to connect to MySQL you need to create a MySQL connection, which you
can do in Dreamweaver, assuming you are using Dreamweaver for your development?
In any event whether you are using Dreamweaver or not you need to provide
MySQL with this basic information:
the server address (this will be localhost if you are testing locally
depending on the port that you have Apache operating on)
If you use Dreamweaver (DW) to create this MySQL connection then DW creates an
include php file for you. DW attaches the include file to each page whenever
you select the connection in a 'server behavior'.
In order to create a MySQL connection you need to have a defind DW site a page
with a document type (php) and a functioning testing server.
I am not sure what you mean by 'no tables showing in the database view', but
if you mean RECORDSETS, the problem could be page construction and handling the
data and/or SELECT query.