How to enable general log in mysql

Mysql opens the general log. After mysql opens the general log, all query statements can be obtained in the general log file in readable mode, but the general log file will be very large, therefore, it is disabled by default. In some cases, you need to temporarily open the general log for troubleshooting and other reasons. Www.2cto.com mysql @ localhost. (none)> show global variables like "% genera % "; + rows + | Variable_name | Value | + rows + | general_log | OFF | general_log_file |/data1/mysql9999/etch171.log | + ---------------- + rows + 2 rows in set (0.00 sec) mysql @ localhost. (none)> set global general_log = on; Query OK, 0 rows affected (0.02 sec) mysql @ localhost. (none)> set global general_log = off; Query OK, 0 rows affected( 0.00 sec)