MySQL Remote connection error prompted analysis

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.