Getting: "MySQL said: 'reading initial communication packet', system error: 0" when connecting through iPhone-network

December 17, 2014 20.5k views
Canfiax
By:
Canfiax

I am often getting this error:

MySQL said: Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0

When I am trying to connect to my database using MySQL. But the actual server (i.e. my app) runs without issues.

It seems only to happen when I am on my iPhone’s cellular datanetwork (using internetsharing). When connected through WiFi hotspots, no errors seem to happen.

Anyone knows what could be wrong?

2 comments
  • Canfiax December 17, 2014

    p.s. I am using Sequel Pro to connect, and I see it succeeds to connect to SSH, but fails at MySQL connecting.

  • Canfiax December 17, 2014

    EDIT: I now realised that this has nothing to do with my celluar data. I am on my home WiFi hotspot now, and it does not work here either. I did a “sudo reboot”, and when trying to reconnect, it works! Why God, why?

Log In to Comment
1 Answer
Woet December 17, 2014

Either your server or your cellular provider is blocking port 3306.

Reply
  • Canfiax December 17, 2014

    I see - can I test if this is positive, and/or try a different port?

  • Canfiax December 17, 2014

    I just did a “sudo reboot” in SSH, and then connected to MySQL. Now it works. But I know in some time, I have to reboot again, and then, if I am lucky, I can connect. What could be causing this?

  • Woet December 17, 2014

    Are you sure MySQL worked for your apps before the reboot?

  • Canfiax December 17, 2014

    @Woet 100%

  • Canfiax December 17, 2014

    I now realised that this has nothing to do with my celluar data. I am on my home WiFi hotspot now, and it does not work here either. I did a “sudo reboot”, and when trying to reconnect, it works! Why God, why?

  • Woet December 17, 2014

    You are out of memory and OOM killer is killing mysqld.

  • Canfiax January 3, 2015

    Well, I only have 512 mb droplet. But not sure this is the issue. I just realized what might be the problem; if I am logged in using Sequel Pro and it crashed, or the connection is disconnected all of a sudden, I cannot relogin. It might be because some user is still not logged out. Could it help?

  • Canfiax January 3, 2015

    Doing sudo /etc/init.d/mysql restart does not solve the issue. Only sudo reboot

Have another answer? Share your knowledge.