javamysqlopencms

unable to set mysqld --max_allowed_packet=16M in opencms installation


i am installing opencms first time ,. I found a problem during installtionerror of my sql max allow packet variable

i have tried SET GLOBAL max_allowed_packet=16777216; and max_allowed_packet=32M ; as per openCms installtion guide, but didnt help.

any idea or help will be appreciated, thanks


Solution

  • Change in the my.ini file. Include the single line under [mysqld] in your file

    max_allowed_packet=32M
    

    and restart mysql server