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?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Either your server or your cellular provider is blocking port 3306.
Click below to sign up and get $100 of credit to try our products over 60 days!
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?
p.s. I am using Sequel Pro to connect, and I see it succeeds to connect to SSH, but fails at MySQL connecting.