Analysis of an error message during MySQL remote connection _ MySQL

Tip: Mysql remote connection: LostconnectiontoMySQLserverduringquery after RH8.0 is installed, you can directly log on to the local machine using mysql, and use mysql-uroot-p to add some users, for example, * beginnerpass indicates that beginner can access this Mysql server using a password anywhere. problem: Mysql remote connection: "Lost connection to MySQL server during query" after RH 8.0 is installed, mysql with its own mysql can be logged on directly on the local machine in the future, use
Mysql-u root-p
Some users have been added, such as * beginner pass
That is, beginner can access this Mysql server from anywhere by using a password (assuming that my mysql server is mysql.test.com), but when I run
Mysql-h mysql.test.com-u beginner-p
The prompt is as follows:
ERROR 2013: Lost connection to MySQL server during query
In fact, I only need to enter
When mysql-h mysql.test.com is used, the above prompt is displayed, that is, it is not the step to verify the password.


This problem is caused by a glibc bug.
In some glibc versions, the gethostbyaddr function (specifically _ nss_dns_gethostbyaddr_r) has a buffer overflow problem, which may cause segment fault when processing big data.

During remote connection processing, mysqld calls the ip_to_hostname () function, then calls the gethostbyaddr function, and the system crashes at the execution of the nss_dns_gethostbyaddr_r function. Therefore, the above situation may occur.

The solution is to upgrade glibc.