PHP and MySQL Connection problem

[pabirds]

I am trying to make a PHP MySQL on a remote server connection in Dreamwesaver CS3.

When I enter the information (host, user, password, etc.) and hit TEST, I get the following error message.

"Access Denied. The file may not exist, or there could be a permission problem. Make sure you have proper authorization on the server and the server is properly configured."

I know the user, password, etc. work, as I can access the MySQL database with other software.

I checked with my host and they say there are no permission problems on their end.

I have checked the settings on the Test Server page in Site Setup and everything looks correct and works there.

I have not seen this particular problem described in other forum postings (although there are a LOT of postings on this topic!).

Any help would be appreciated.

[RJweb]

I know you are using remote, but is your testing server on? if not turn that on and see if that does it. it just happened to me working on remote server and could not get mysql conn to work, until I turn on my testing (developer server), then I was able to connect to mysql and the tables that I created in phpmyadmin remotly was downloaded.

[pabirds]

I thought my testing server was the remote server and is always on as far as I know. I don't know how to turn it on or off.

Is there some other testing server that I should be aware of?

Frank

Date: Wed, 3 Jun 2009 15:43:02 -0600

From: forums@adobe.com

To: fchbmh@hotmail.com

Subject: PHP and MySQL Connection problem

I know you are using remote, but is your testing server on? if not turn that on and see if that does it. it just happened to me working on remote server and could not get mysql conn to work, until I turn on my testing (developer server), then I was able to connect to mysql and the tables that I created in phpmyadmin remotly was downloaded.

>

[David_Powers]

pabirds wrote:

I have checked the settings on the Test Server page in Site Setup and everything looks correct and works there.

How do you know? That is the most likely place the problem lies in. Post your settings (obviously leaving out the login username and password).

[Guest]

Yea, it is.. U have to be assure that your server is on otherwise you can't connect to your server. If u sure that ur server is always on, there might be problems with your site or authorization setting.

[speedingyeti · Accepted solution]

pabirds, I was having the exact same problem. Here is the solution which worked for me:

1. make sure you have clicked the Advanced tab in the Site Definition pane, then

2. choose Testing Server, from the list on the left side of the pane, then

3. set FTP Host to the host for your site, ex. ftp.yoursite.com  or  ftp.yoursite.eu, then

4. set the Host Directory depending on your hosting service's hierarchy, it will probably be something like, domains/  www/  or  htdocs/. To determine this, when you have Dreamweaver's Files window open in two-column view, expand the root folder of your site. Then

5. set your URL Prefix to the root URL of your site, ex. http://www.yoursite.com/  or  http://www.yoursite.eu/, then

6  use your user/pass combination for login.

I my case, step 4 was the cause of my sudden increase in grey hair, and raised blood pressure.

hopefully this helps.

speedingyeti