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';and
GRANT 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.