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 GLOBAL
mysql> 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)
mysql> show variables like '%general%';+------------------+-----------------------------------+| Variable_name | Value |+------------------+--------------------------