安装opencms使用mysql数据库时，出现错误 Java代码
- MySQL system variable 'max_allowed_packet' is set to 1048576 Byte (1MB).
-
- Please note that it will not be possible for OpenCms to handle files bigger than this value in the VFS.
-
- Error while checking the server configuration!
-
- -------------------------------------------
-
- Your 'max_allowed_packet' variable is set to less than 16777216 Byte (16MB).
-
- 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！
下载本文
