Skill problem MySQL remote connection appears "Lost connection to MySQL server during query" installed RH 8.0 with its own MySQL after the use of MySQL directly on the computer can be used to log on normally, with
Mysql-u root-p
Added some users, such as * beginner Pass
That is, beginner can access this MySQL server from anywhere via a password (assuming my MySQL server is mysql.test.com) but when I run
Mysql-h Mysql.test.com-u Beginner-p
On the tip:
ERROR 2013:lost connection to MySQL server during query
Actually, I just need to type
Mysql-h mysql.test.com appears above the hint, that is, it has not yet to verify the password that step. <br>
This problem is caused by a bug in glibc.
In some versions of glibc, the GETHOSTBYADDR function (exactly _nss_dns_gethostbyaddr_r) has a buffer overflow problem that can cause segment FAULT when processing large data.
When processing a remote connection, MYSQLD calls the Ip_to_hostname () function, which then calls the GETHOSTBYADDR function, and the system crashes at the execution Nss_dns_gethostbyaddr_r function. Therefore, the above situation will occur.
The way to solve the problem is to upgrade glibc.