Answer the question
In order to leave comments, you need to log in
Max_allowed_packet is automatically reset in MySql, how to treat?
Hello to all.
On the VPS server I'm running Ubuntu 14.04.4 LTS and MySql Ver 14.14 Distrib 5.5.49, for debian-linux-gnu (x86_64) using readline 6.3.
The problem is the following, after some interval the max_allowed_packet parameter is reset to 1mb, I have a global parameter set in my.conf, restarting the server helps.
Can someone come across? maybe someone knows how it can be treated or how to find the source of the problem.
Googled, there are a lot of suggestions, up to the fact that "You were hacked": D, but I could not figure it out.
Thank you!
Answer the question
In order to leave comments, you need to log in
This setting is never reset automatically. Under any circumstance, this is done by the executable command.
Try to take away the "SUPER" rights (allowing SET GLOBAL) from the user on behalf of which your application is running:
REVOKE SUPER ON *.* FROM 'username'@'localhost';
FLUSH PRIVILEGES;
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question