MySQL Forums
Forum List  »  Newbie

Re: max_allowed_Packet automatically reset to 1M
Posted by: Peter Brawley
Date: March 22, 2016 11:09AM

Well, there are three main possibilities ...

1. The server restarted with a different my.cnf. You can rule that in or out by inspecting the server log.

2. Someone with SUPER privilege is running a script that changes the max_allowed_packet value. You can fix this by setting the SUPER privilege of everyone except root to 'N', and of course ensuring that only you can login to the DB as root.

3. You have a rogue user, ie you've been hacked. The app doesn't login as root, does it? Turn on the general query log, wait for the value to reset, then inspect the query log.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.