Connecting Mysql database in dreamweaver

[defietser]

Dear forum members,
When I try to approach Mysql database through dreamweaver I get the following error:

HTTP Error code 404 File Not found. Here are some possible reasons for the problem:
1) There is no testing server running on the server machine,
2) The testing server specified for this site does not map to the http://www.xxxxxxx.xx/-mmServerScripts/MMHTTPDB.php URL.
3) Verify that the URL Prefix maps to the root of the site.

Can someone help me to solve the problem!

Sincerely
Defietser

 

[hamed]

have you enabled remote access for the database?
It can be found at mysql management page.

 

[defietser]

It can be found at mysql management page.

Where?

I went to mysql management
Modify User Privileges and these are the settings


Select Yes Insert Yes
Update Yes Delete Yes
Create Yes Drop Yes
Alter Yes Index Yes
Grant No Reference Yes
Create tmp tables Yes Lock Tables Yes

what should I change?
thanks
Defietser

 

[hamed]

under mysql management page, select the database you need, and at the bottom of that page, you can see "access hosts".
Add your IP address there.

 

[defietser]

Which IP address? my website or my router.
Thanks
Defietser

 

[GXX]

Whatever IP your computer is using that dreamweaver is running on.

 

[defietser]

Thanks for the replay but i found the anser here:
http://forums.codewalkers.com/php-coding-7/mmserverscripts-folder-878206.html

How about this:
(this is gotten online, dont know about it from personal expierence)

1. Open your ftp program
2. Go into the root folder of your site (the "Host directory" set in dreamweaver)
3. Look for a folder named _mmServerScripts


If it's there

1. Delete _mmServerScripts
2. Attempt to connect with dreamweaver again
3. Dreamweaver should now create the new directory and it's contents


If it's not there

1. Create _mmServerScripts directory
2. Go to your dreamweaver install directory and then Configuration\Connections\Scripts\PHP_MySQL\_mmDBS cripts
3. Upload MMHTTPDB.php and mysql.php to the _mmServerScripts directory on your server

The folder was on the server, but not in the root of the website. I moved the folder to the root and problem solved!!

Thanks
Defietser