All geek questions in one place

Update max_allowed_packet

I have my application hosted on a shared server, I can’t access the my.cnf / my.ini file from my account, max_allowed_packet is only set to 1M. Now I need to change it to 32M, is that their any idea of ​​either PHP or .htaccess to change its value?

Thanks and Regards Prajjwal

+3
source share
1 answer

max_allowed_packet allowed for dynamic values, this means you just need to login to mysql console

show variables like 'max_allowed_packet';
set global max_allowed_packet=33554432;

log out and log back in

show variables like 'max_allowed_packet';

If you don’t have a console login, try PHP to work the same way.

+7
source

Source: https://habr.com/ru/post/1786882/

More articles:


All Articles