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.
Adobe DreamweaverMySQL Server

Avatar of undefined
Last Comment
Jason C. Levine

8/22/2022 - Mon
Jason C. Levine

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.
ASKER
rmb8024

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.
Jason C. Levine

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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
rmb8024

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

Okay.

1) Where is the testing server for this site?

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

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jason C. Levine

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?
ASKER
rmb8024

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
Jason C. Levine

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
rmb8024

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!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Jason C. Levine

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