I am using the DB Connection tool in Dreamweaver MX 2004 - and I am a bit lost on why it will not connect. I have created the DB in CPanel - I have assigned permissions, and here is the resulting access code:

CODE
$dbh=mysql_connect ("localhost", "USERNAME", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("DBNAME");


So when I go into the MySQL Connection tool it asks for the following info:

Connection Name:

MySQL Server:

User Name:

Password:

Database:

Connection name: - I think I can make whatever I want

MySQL Server: - I have tried the IP address, name of server, URL of site etc...not sure where else to go with this...

User name: - obvious

Password: - obvious

Database: - seems obvious - domainassignedname_name - but even if I browse - it comes back unable to connect to even browse to find available.


Here is the error Dreamweaver is kicking out to me:

QUOTE
Error 404 Http File not found, here are some possible reasons for the problem:

1) There is no testing server on the server machine.
2) The testing server specified for this site does not map to the htp://200.13.168.100/public_html/_mmserverscripts/mmhttpdb.php.URL. Please verify that the URL Prefix maps to the root of the site.


Just as an FYI - I have the Site defined with the Root folder as "Blank" so I am seeing in my directory Remote View - all Root level folders...

Thanks for your grand wisdom...

Rich