PHP and MySQL Connection problem

Question

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.

speedingyeti · Accepted Answer

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

Anonymous · Answer

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.