CODEWITHSUNDEEP
mysql
Abhishek Ginani
Abhishek Ginani

Reputation: 4751

MySQL variable `max_allowed_packet` auto resetting to 1MB

MySQL variable auto setting to 1MB every day. I have already set it to the 256MB in MySQL config. I have enabled General query Log to see who is changing the variable and found that someone has fired SET GLOBAL max_allowed_packet=1024 to set this variable.

Is there any way to prevent user setting this variable from query?

How to revoke privileges from user for updating config variables?

Upvotes: 0

Views: 1775

Answers (1)

Firat Akandere
Firat Akandere

Reputation: 523

Ah, you should revoke "super" privileges. It gives permission to use SET GLOBAL.

REVOKE SUPER ON *.* FROM 'username'@'localhost';
FLUSH PRIVILEGES;

http://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_super

Upvotes: 3

Related Questions