Re: max_allowed_packet error

[Javier Treviño]

Hi Kaji Pasa,
Is there a relation between your described issue and the MySQL for Excel product?
Just wondering since this forum is for that specific product.

Maybe you have not been able to set the max_allowed_value using the SET command because your user does not have the SUPER privilege:
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html

Or you can follow the instructions here:
https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html

The INI file you are looking for may be in "C:\ProgramData\MySQL\MySQL Server X.X". If you add the value there you will need to restart the Server, but the change will be permanent (unlike setting it through the SET command).

Best regards.

====================================
Javier Treviño
MySQL on Windows Team