查看服务器日志报错提示:Mysql You can change this value on the server by setting the max_allowed_packet’ variable. Packet for query is too large (6933997 > 4924304). You can change this value on the server by setting the max_allowed_packet’ variable.
解决办法:
(1)找到Mysql的配置文件my.ini(Windows系统),参考步骤2-3。
(2)Mysql安装时在默认路径下,此时需要打开隐藏文件夹找Mysql的安装配置文件;依次打开ProgramData\MySQL\MySQL Server 5.6
(3)找到my.ini文件后打开,修改"max_allowed_packet = 4M"为"max_allowed_packet = 20M";保存文件后重启Mysql服务器。
有以上三个步骤可解决报错问题。
解决Mysql You can change this value on the server by setting the max_allowed_packet' variable. 异常
最新推荐文章于 2023-05-05 23:07:08 发布