本文共 1017 字，大约阅读时间需要 3 分钟。

mysql> show variables like '%general%';+------------------+-----------------------------------+| Variable_name    | Value                             |+------------------+-----------------------------------+| general_log      | OFF                               || general_log_file | /opt/mysql_data/server0/mysql.log |+------------------+-----------------------------------+2 rows in set (0.00 sec)mysql> set general_log=ON;ERROR 1229 (HY000): Variable 'general_log' is a GLOBAL variable and should be set with SET GLOBALmysql> set global general_log=ON;Query OK, 0 rows affected (0.00 sec)mysql> show variables like '%general%';+------------------+-----------------------------------+| Variable_name    | Value                             |+------------------+-----------------------------------+| general_log      | ON                                || general_log_file | /opt/mysql_data/server0/mysql.log |+------------------+-----------------------------------+2 rows in set (0.00 sec)

set global general_log=ON;

转载地址：http://gzbxi.baihongyu.com/