查看日志时区

show variables like 'log_times%';

默认为UTC

将时区设置与本地一致

vim /etc/mysql/mysql.conf.d/mysqld.conf

[mysqld]
log_timestamps = SYSTEM

重启服务

systemctl restart mysql