Link to home
Start Free TrialLog in
Avatar of rmb8024
rmb8024Flag for United States of America

asked on

Dreamweaver MySQL Connection Error

I am trying to setup a site within Dreamweaver CS4 and I have never had so much trouble. I have successfully setup and connected to the remote and testing servers. I am now trying to add my MySQL database but continue to receive the following error:

MySQL Error#: 2013
Lost connection to MySQL server at 'reading initial communication packet', system error: 110

Using the same settings I am able to connect to the database using Navicat for MySQL. Ideas?

This is usually a straight forward process but this is my first attempt to do this using Rackspace Cloud as my host.
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

Hi rmb8024,

Error 2013 usually means there is a problem on the MySQL server end of things, not Dreamweaver.

Verify the MySQL server is up and running and listening on the correct ports for web traffic.
Avatar of rmb8024

ASKER

Yes, I have verified the server is fine. I am able to connect using Navicat for MySQL, and phpMyAdmin. The issue seems to be isolated to Dreamweaver.
Dreamweaver uses mysql_pconnect() (persistent connection) to do its thing.  Open your connection file and change that to mysql_connect() and see if works any better.
Avatar of rmb8024

ASKER

That was a good idea but unfortunately I get the same error when I test the MySQL connection.
Okay.

1) Where is the testing server for this site?

2) Does the mysql user have permission to access from any IP address?
Avatar of rmb8024

ASKER

1) The testing server is the same physical server as the remote (live) server. I am using Rackspace Cloud as the host Do you need any more info then that?

2) Yes, I can only assume it does as I am able to use the same connection information in Navicat to access the database remotely.
1) No, no more info than that.

2) Weird.  It's almost as if DW itself is being blocked.  Can you check firewalls and other security software/appliances to be sure DW can connect out?
Avatar of rmb8024

ASKER

That is what is strange, I can select any of my other sites with databases and it connects fine. That said, none of my other sites are hosted at Rackspace Cloud.

I contacted Rackspace but all their tests say it is operating fine. They conclude I must have a setting incorrect in Dreamweaver somewhere.
ASKER CERTIFIED SOLUTION
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rmb8024

ASKER

Jason,

Rackspace gives an IP to connect to when remotely accessing MySQL but to connect from within the script loaded on the server it is a hostname. I had tried using the hostname previously but it gave the same result.

I tried again after your last suggestion and the hostname works! The IP still does not. Very interesting because even Rackspace told me the hostname will not work.

Thanks for your patience and all your help!
>> Very interesting because even Rackspace told me the hostname will not work.

That is weird.  If it causes you problems in the future, you can always edit the connection file and replace the hostname with the IP address.