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

rahulvishwakarma · 09-23-2020, 02:39 AM

hi to all, I've centos 6 as mysqlserver and centos7 as client in VMs. when i tried to connect to server it show

following error :

Code:

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

but from other hosts like centos67client i can easily connect to mysql server.
how to get rid of this error.

berndbausch · 09-23-2020, 08:48 PM

Here is a bug matching your description: https://bugs.mysql.com/bug.php?id=80260. It's old, but so is your Centos 6 server.

A search for "system error: 104" yields more results. You need to find out which result fits your configuration.

TB0ne · 09-24-2020, 09:19 AM

Quote:

Originally Posted by rahulvishwakarma

hi to all, I've centos 6 as mysqlserver and centos7 as client in VMs. when i tried to connect to server it show following error :

Code:

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

but from other hosts like centos67client i can easily connect to mysql server. how to get rid of this error.

Read the "Question Guidelines", and do basic research before posting. An administrator with ten years experience should easily be able to at least do some research on their own.

This error is found in the MySQL documentation, which you can read on their website, and indicates a routing/network error of some sort. Since you provide no details at all about your network, we can't help you further. Probably related to your other (several) network-related threads:
https://www.linuxquestions.org/quest...er-4175664546/