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

March 31, 2019 1.8k views
MySQL CentOS

Hi,

I saw many Q&As regarding this problem.
Here is what I did for troubleshooting:

  • I saw that the server is listening on the SQL default port:
    netstat -ntlp | grep 3306
    tcp6 0 0 :::3306 :::* LISTEN 3092/mysqld

  • /etc/mysql/my.cnf was empty

  • IpTables was empty.

  • telnet <My IP> 3306 -> resulted in correct manner

I feel a little bit clueless... If someone can help I would be gracious. Also, I would be happy to understand exactly what does this error say, b/c if I try to connect with my MySQL workbench to some random IP I get a different error.

Many Thanks,
Tomer.

1 Answer

This is confusing indeed. Error 0 means success.

$ perror 0
OS error code   0:  Success

Can you add this to your [mysqld] section in my.cnf:

bind-address = 0.0.0.0

Restart MySQL. Can you also post the output of this command from your workstation (not server):

telnet DROP.LET.IP.ADDRESS 3306

Cheers

  • Hi @unixynet,

    Thanks for your reply.

    First of all thanks to your reply, I understood that I am opening an imaginary file and I was opening my.conf in the wrong place.

    I added the bind-address = 0.0.0.0 and restarted mysql.

    When I did telnet <ip> 3306 from my pc I get an empty screen (which is from my understanding a good thing)

    Still, the problem is persistent.

    Thanks,
    Tomer

Have another answer? Share your knowledge.