hello guys

I am having some problem with connecting a database by using dreamweaver mx

in the mysql connection dialog box , i insert all the right information but still i get the following

so when i click the test button in order to see if dwmx connected to the database successfully i get this " 1:There is no testing server running on the server machine .


: The testing server specified for this site does not map to the http://localhost/_mmServerScripts/MMHTTPDB.PHP Verify that the url prefix maps to the root of the site .
so that is the problem . I don't know how to go about it .So Iam expecting your help.

thank you

From Cpanel:
1) Create your database
2) Add a user
3) Add 2 hosts (further down the page..currently should have only localhost listed): servername.domain.com and your account username (not the db username). Both hosts are needed, as the server will apped your username onto the connection request like: user@server.domain.com.

From DWMX:
Open any PHP document.
1) From the database tab (Application window: database tab) Choose the plus + sign and create the database connection. This should open a window where you can set the details of your connection. Use your database username here where it asks for it. MySQL server should get the IP of the site.
2) Set up testing server (Application window: server tab)
Set up the details for the testing server. No surprises here, just fill in the blanks. [Make sure the URL prefix at the bottom of this window has your address as http://www.domain.com with nothing following the TLD]
3) Open DW preferences and find "site". Look for the timeout setting and change it to 60 seconds (default is 15). This should remove the mysterious FTP error common when connecting this way. Drove me crazy until I saw how long it took to connect.
4) Go back to #1, double click on the name of the connection you created, and choose 'test' in the next window to make sure your efforts worked.

thank you for the help , but there is this "Access Hosts:
192.168.1.%
4ulyrics.com
localhost

but i can't add my account username because there is no field for it . what can i do? I have already created the database and gave it a name and username and password.

Access host should have:
domain.tld
username
localhost

192.168.1.x is your local LAN IP, and doesn't matter here. The database and username in DW should match the ones in your db on the server. Make sure you're using the full username (user_dbname).

Make sure you're using the full username (user_dbname).
In Dreamweaver...sorry. On the server, just the cpanel username.

still can't get it

I'm sorry then. The method I gave works perfectly from here. All I can suggest is that you go over the settings very carefully to see if you might have done something a little differently than shown.

hint"Verify that the url prefix maps to the root of the site"
http://localhost is not the root of the site. "http://www.domain.tld" is...

well then should i ignore the ) Add 2 hosts (further down the page..currently should have only localhost listed): servername.domain.com and your account username (not the db username). Both hosts are needed, as the server will apped your username onto the connection request like: user@server.domain.com.

I mean i did everything you told me except the username of my account .

Have a look here, paying careful attention to the URL at the bottom. Does yours have all the same sort of settings (Dreamweaver: testing server setup dialog)?
http://69.56.205.235/mx_connect.gif

I just tested this, and connected perfectly.