欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

MySQL system variable 'max_allowed_packet'_MySQL

程序员文章站 2022-05-30 15:49:44
...
安装opencms使用mysql数据库时,出现错误 Java代码 MySQL system variable 'max_allowed_packet'_MySQL
  1. MySQL system variable 'max_allowed_packet' is set to 1048576 Byte (1MB).
  2. Please note that it will not be possible for OpenCms to handle files bigger than this value in the VFS.
  3. Error while checking the server configuration!
  4. -------------------------------------------
  5. Your 'max_allowed_packet' variable is set to less than 16777216 Byte (16MB).
  6. The required value for running OpenCms is at least 16MB.Please change your MySQL configuration (in the my.ini or my.cnf file).


解决如下:



这个问题是因为导入的sql文件大于系统默认的max_allowed_packet的值,解决方法:比如在my.cnf修改增加 到:max_allowed_packet=16M #或者更高,当然也可以在mysqld启动的时候加入这个参数,但是该变量必须在mysqld重新启动的时候才加载生效,所以必须重起mysqld!