Error no.2013 Lost connection to Mysql server during query

Source: Internet
Author: User

System:
[Email protected] ~]# cat/etc/redhat-release
CentOS Release 6.3 (Final)

DB version:
Mysql> SELECT @ @version;
+------------+
| @ @version |
+------------+
| 5.6.26-log |
+------------+

Data Center Department applies for on-line database SELECT permission, direct grant Select on db.* to ' username ' @ ' IP ' identified by ' password ';

Use MARIADB to do multi-source copy and filter the user mobile phone number and address, so add whitelist, and email feedback to the data center of the beauties!!

Connection not on database, error: Error no.2013 Lost connection to Mysql server during query

Whenever beautiful women find you work, always attentive to help, haha haha!!  The past looked down, the ping does not pass. Active Contact Network Management open permission, Ping Pass, Telnet Pass, the problem is still, not connected!

Problem can be completely excluded from the database permissions control level, Baidu look where the problem!

Many users ask to modify:
max_allowed_packet=64m
And my size is:
Max_allowed_packet=32m, and then know the point of the problem is not here, and tried, the problem is still.

Finally Google to come, a foreigner encountered the same problems as I, ping Pass, Telnet, Max_allowed_packet modified to 64M, the problem is still!
Links: https://www.zabbix.com/forum/showthread.php?t=47910

Finally, firewall policy issues!



Re-let the network management changes under the policy, OK, connected! If it weren't for the girls in the data center, they wouldn't go to see it, haha haha ha!

Error no.2013 Lost connection to Mysql server during query

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.