Workaround for Database report packet for query is too large (1986748 > 1048576) (MySQL write data is too large)

WORKAROUND: A system parameter for MySQL: Max_allowed_packet, which defaults to 1048576 (1M),

Enquiry: Showvariables like '%max_allowed_packet% ';

Modify the value of this variable:

The MySQL installation directory

"Max_allowed_packet = 1M" In the [Mysqld] segment of the My.ini file (some files may not be in this line)

The format is:

[Mysqld]

Max_allowed_packet = 1M (change 1M to 4M (if there is no line, add one line)),

Save

Restart the MySQL service.

Linux: Go to/etc/my.cnf file modification max_allowed_packet = 1M change 1M to 20M problem resolution!

Workaround for Database report packet for query is too large (1986748 > 1048576) (MySQL write data is too large)