Error

ERROR 2006 (HY000) at line 1041: MySQL server has gone away

Solution

Location in Xampp Server

/opt/lampp/etc/my.cnf

The error message “MySQL server has gone away” usually occurs when the client cannot connect to the MySQL server. This can happen for a variety of reasons, including but not limited to:

1. Timeouts: The server closed the connection due to inactivity. This happens if the client was idle for more than wait_timeout seconds or if a network problem caused a disconnect.
2. Packet Too Large: The client tried to send a packet bigger than max_allowed_packet. Increasing the max_allowed_packet size on the server or breaking down the data into smaller chunks from the client side can resolve this.
3. Server Restarted: The MySQL server was restarted, which also closes all connections.
4. Out of Memory: The server could not allocate memory for the connection or was killed by the system (OOM Killer) due to out of memory.
5. Wrong Connection Parameters: The connection parameters (host, username, password) are incorrect.
6. Network Issues: There could be network connectivity issues between the client and the server.

To resolve this error, consider the following actions based on the possible causes:

• Increase Timeouts: Increase the wait_timeout and interactive_timeout on the MySQL server if connections are dropping due to inactivity.
• Increase Max Allowed Packet: Increase the max_allowed_packet size in the MySQL server configuration. This is particularly important if you’re dealing with large blobs or long queries.
• Check Server Status: Ensure that the MySQL server is running and that there are no recent restarts or crashes.
• Optimize Queries and Data: If you’re sending large amounts of data, consider breaking it down into smaller chunks.
• Check for Network Issues: Verify that there are no networking issues between the client and server. Tools like ping and traceroute can help diagnose such problems.
• Server Configuration and Logs: Check the MySQL server’s error log for any messages related to connections being killed or other errors that might indicate why the server is unavailable.

Error

ubuntu@ip-172-31-41-444:~$ sudo /opt/lampp/lampp start
Starting XAMPP for Linux 8.2.12-0...
XAMPP: Starting Apache...already running.
XAMPP: Starting MySQL.../opt/lampp/share/xampp/xampplib: line 22: netstat: command not found
ok.
XAMPP: Starting ProFTPD.../opt/lampp/share/xampp/xampplib: line 22: netstat: command not found
ok.

Solution

# Debian, Ubuntu, and derivatives
sudo apt update && sudo apt install net-tools

# CentOS, RHEL (up to version 7), and derivatives
sudo yum install net-tools

# CentOS/RHEL 8, Fedora
sudo dnf install net-tools

# Arch Linux, Manjaro
sudo pacman -Sy net-tools

# openSUSE
sudo zypper install net-tools

# Alpine Linux
sudo apk add net-tools