Skip navigation
pabirds
pabirds
Currently Being Moderated

PHP and MySQL Connection problem

Jun 3, 2009 1:36 PM

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.

 

 

 

 

 

640 Views   5 Replies   Latest reply: speedingyeti, Jun 9, 2009 2:53 AM
 
Replies
  • RJweb
    Currently Being Moderated
    1. RJweb,
    Jun 3, 2009 2:42 PM   in reply to pabirds
    Report

    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.

     
    |
    Mark as:
  • pabirds
    Currently Being Moderated
    2. pabirds,
    Jun 4, 2009 4:34 AM   in reply to RJweb
    Report

    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: Re: PHP and MySQL Connection problem 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.

    >

     
    |
    Mark as:
  • David_Powers
    Currently Being Moderated
    3. David_Powers,
    Jun 4, 2009 11:02 AM   in reply to pabirds
    Report

    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).

     
    |
    Mark as:
  • QiQi86
    Currently Being Moderated
    4. QiQi86,
    Jun 8, 2009 12:34 AM   in reply to pabirds
    Report

    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.

     
    |
    Mark as:
  • speedingyeti
    Currently Being Moderated
    5. speedingyeti,
    Jun 9, 2009 2:53 AM   in reply to pabirds
    Report

    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

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points