SQLyog reported an error when importing the database
Error Code: 2006-mysql Server has gone Away
Max_allowed_packet (a parameter of MySQL) is not set to a large enough value.
Modify directly using SQL statements:
The SET GLOBAL max_allowed_packet = 671088640;
This works well, after the change, there is no need to restart the service, it works directly
Error Code: 2006-mysql Server has gone Away
Max_allowed_packet (a parameter of MySQL) is not set to a large enough value.
Modify directly using SQL statements:
The SET GLOBAL max_allowed_packet = 671088640;
This works well, after the change, there is no need to restart the service, it works directly
Read More:
- (error when importing database): MySQL 2006-mysql server has gone away
- MySQL Workbench: Error Code: 2013. Lost connection to MySQL server during query solution
- MySQL: if the remote connection using navicatip fails, prompt “is not allowed to connect to this MySQL server”
- The MySQL service suddenly hangs up with the error message can’t connect to MySQL server on ‘localhost’ (10061)
- The server just without updating PID file and can’t connect to local MySQL server through socket are solved
- It can’t connect to local MySQL server through socket ‘/ tmp/ mysql.sock ‘(2) “;
- When MySQL is running, the server suddenly goes down, which causes Mysql to be unable to restart
- Unable to install SQL Server (setup.exe), VS Shell installation has failed with exit code 1638.
- MySQL installation failed: dpkg: error processing package MySQL server (- – configure): dependency problem
- ERROR 2002 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
- MYSQL login error: mysqladmin: connect to server at’localhost’ failed
- The MySQL server is running with the — secure file priv option
- Cannot connect to MySQL server on “host” (113)
- Error 2003 (HY000): can’t connect to MySQL server on ‘localhost’ (10061)
- ERROR 2005 (HY000): Unknown MySQL server host
- [mysql] “Failed to start MySQL Server” error resolution
- MySQL restart error the server quit without updating PID file
- Error 2005 (HY000) unkonw MySQL server host…
- The action ‘install’ for product ‘MySQL server 5.7.19’ failed
- Can’t connect to MySQL server on ‘192.168.64.132‘