I got this error when trying to connect to my MySql Server sitting on a new Server I opened, using MySql workbench.
Failed to connect to at :3306 mysql with user . lost connection to mysql server at reading initial communication packet, system error: 0
I see that this issue was spoken about a lot but I truly did not find an answer. Here is what I tried:
- The iptables is not the problem since when testing via telnet 3306 I get a connection. Also I tried to connect when IpTables was turned off.
- Erased the bind 0.0.0.0 from the my.cfd file. (As mentioned above I have a connection with my server with the 3306 port, so it couldn't be the problem)
- Of course I did:
CREATE USER 'developer'@'%' IDENTIFIED BY 'dev_password';
andGRANT ALL ON *.* TO 'developer'@'%';
I can't get what's the problem since there is a connection to my servers IP over this port, there for the problem should be somehow on the application level of mysql.
Even though this problem was talked about here here here etc. I would be very grateful for a direction for a solution. Also, I would be really happy if someone can explain the problem.