mysql> SHOW VARIABLES LIKE 'general_log%';
+------------------+---------------------------------------+
| Variable_name    | Value                                 |
+------------------+---------------------------------------+
| general_log      | OFF                                   |
| general_log_file | /usr/local/mysql/data/Lucking-Mac.log |
+------------------+---------------------------------------+

关闭 general_log

SET GLOBAL general_log = 'OFF';

重开 general_log（MySQL 会自动重新创建文件）

SET GLOBAL general_log = 'ON';

➤ 查看文件尾部（实时追加更新）

tail -f /usr/local/mysql/data/Lucking-Mac.log

cat /usr/local/mysql/data/Lucking-Mac.log

✅ 方法一：使用 shell 清空日志内容（推荐）

sudo truncate -s 0 /usr/local/mysql/data/Lucking-Mac.log