#2006 - MySQL server has gone away in mysql?

Question

I try to import the excel showing error message.how to set max_allowed_packet in XAMPP. kindly share folders name and file name.

Answer 1

Change the value on this file C:/xampp/mysql/bin/my.cnf using notepad or any other text editor. Increase max_allowed_packet as needed

your file might look like this,

Restart mysql service