Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large

上传文件的时候报的错误:

Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (11756325 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3865)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2551)

MYSQL会根据配置文件会限制server接收的数据包大小

怎么修改呢?!

1. 进入Mysql

C:\Users\john>mysql -u root -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.5.60 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show variables like '%max_allowed_packet%';

2.查看设备的最大值
show variables like ‘%max_allowed_packet%’

3.设置你想要的文件大小
set global max_allowed_packet = 3* 1024 * 1024 * 10;

4.退出重新进去查看