By rjohnsonh on

Hi fellows!

I have a problem with the MySql comunication. The hosting server changed MySql platform to 5.0 version, now my site shows this error: "Lost connection to MySQL server at 'reading initial communication packet', system error: 61"

I use the 4.6 Drupal version... what can I do it? Install everything again? change version... or what?

Thanks

⋅ Categories: Drupal 4.6.x

Comments

twen’s picture

twen commented

Hello, the problem is not related to drupal. but to mysql server or client. A workaround is know, but this seems to be a bug resoleved bug....

More here : http://forums.mysql.com/read.php?52,151255,156258#msg-156258

In short : in your mysql connexion file, don't use the IP address of the server, but it's name.

ablemike’s picture

ablemike commented

You can set MySQL to listen on specific addresses.
I had this same issue. I solved it by letting MySQL listen on any address. Not just 127.0.0.1

I access MySQL from a different box though.

--
Michael Bishop

ablemike’s picture

ablemike commented 
cd /etc/mysql
sudo nano my.conf

Find the bind-address 127.0.0.1 and comment it out.

--
Michael Bishop

becca08’s picture

becca08 commented

I had the same error but different circumstances, I'll share the solution here in case anyone comes over this thread . . .

I needed to set up a local server

so I installed mamp on my macbook pro running OSX 10.5.4 Leopard, (after some reorientation - I was migrating from a Windows machine) I managed to get the Default Drupal site up and running but as I was wanting a multisite installation this was only the first step.

After setting up a few more dbs and Virtual Hosts etc I kept running into this error every time i tried to access the subsequent sites

"Lost connection to MySQL server at 'reading initial communication packet', system error: 61"

After days of looking I found a very simple solution:

Opened MAMP>Preferences>PORTS> pressed 'Set to Default Apache and MySQL ports'
so instead of 8889 it is now 3306

(I had already changed my Apache port to 80 on the advice of another thread)

This is the video from the awesome Addi Berry that helped me finally get it right! recommended viewing.
http://www.lullabot.com/files/MacLocalhost.mp4

Hopes this helps someone out there in the wide world of web ;)

Cheers
Bec

ryosaeba’s picture

ryosaeba commented

Dear becca08

I've your same problem on my laptop mac book pro with MAC OS X 10.5.6 and MAMP.

I followed your instructions but still have the problem "Lost connection to MySQL server at 'reading initial communication packet', system error: 61"

johncongdon’s picture

johncongdon commented

I was having the same problem and it turned out the traffic was blocked by a firewall. Try telnetting to your mysql server to know for sure.

telnet mysql_server 3306

jtrogo’s picture

jtrogo commented

I solved my "Lost connection to MySQL server at 'reading initial communication packet', system error: 61" on my mac by turning on the server instance at settings

tapas_talukder’s picture

tapas_talukder commented

I have got the same issue when I try to run my db 2 db (D6 to D7 migration ) migration. But our site was running.
The below error was showing .

PDOException: SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in DrupalVersion6->getDefaultFormatMappings()

Then I have checked our D6 db server, which mysql services was not running.Then I have run the mysql services of D6 db server and the issue has solved.

So when you got the error msg, please check your mysql services is running or not.