Mysql被攻击

日志：
show global variables like '%general%';
set global general_log=on;

默认Path：/var/run/mysqld/mysqld.log
general_log是外部csv文件，若想提高查询性能：alter table general_log engine=myisam;

被修改参数：max_allowed_packet=20M
查看方法：show variables like '%max_allowed_packet%';
set global max_allowed_packet=20M

修改密码：
mysql<
use mysql;
update user set Password=PASSWORD('XX') where user='root';
flush privileges;

转载于:https://www.cnblogs.com/music378/p/6824829.html