Error Code: 2006 – MySQL server has gone away

What are the eight life cycle hook functions of Vue>>>

Copyright notice: please indicate the original address

The reason for this problem is that the file is too large when importing data


1. For Linux system, find the configuration file my.cnf and modify it to a larger value in [mysqld]:

max_ allowed_ packet=6000000M

wait_ timeout=600000

interactive_ timeout = 600000

(it means that the maximum allowable packet size is 16m, and the waiting time-out/activity failure time is 600000 seconds)

2. If it is a Windows system, the general configuration file is my.ini

3. If the configuration file cannot be found, you can run the following statement:

SET GLOBAL max_ allowed_ packet=6000000;

4. Remember to restart mysql


Let’s learn and grow together

Program development group Linux, C: 368848856
Shanghai web development group PHP/ASP: 452703835 (beginner)
verification information: second in charge

Similar Posts: