为什么mysql max_allowed_packet自动重置为1m

本文介绍了为什么mysql max_allowed_packet自动重置为1m的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我设置了

SET GLOBAL max_allowed_packet=16777216;

还有

[mysqld]
max_allowed_packet = 16M

我通过以下命令检查了max_allowed_packet

I checked the max_allowed_packet through below command

SHOW VARIABLES LIKE 'max_allowed_packet';

值是= 16777216

and the value is = 16777216

但是几天后max_allowed_packet会自动重置为1M.

But after some days max_allowed_packet automatically reset to 1M.

推荐答案

我很确定您被黑了.我有同样的问题几个月.我打开了general_log，最后找到了一些代码:

i am pretty sure that your are hacked. i had the same problem for months. i opened general_log and finally found some codes:

   connect root@someipaddress on
   Query select 0x4D5A900..........(verylong)
   Query select sys_exe('cmd /c  c:/windows/nbvqc4.vbs')
   .........
   set global max_allowed_packet 1024
   ........

建议:更改您的root密码.

suggestion: change your root password.

这篇关于为什么mysql max_allowed_packet自动重置为1m的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

1M