查询日志级别的定义
mysql> show variables like '%log%';
+-----------------------------------------+----------------------+
| Variable_name | Value |
+-----------------------------------------+----------------------+
| back_log | 80
| binlog_cache_size | 32768
| binlog_checksum | CRC32
| binlog_direct_non_transactional_updates | OFF
| binlog_format | STATEMENT
| binlog_max_flush_queue_time | 0
| binlog_order_commits | ON
| binlog_row_image | FULL
| binlog_rows_query_log_events | OFF
| binlog_stmt_cache_size | 32768
| binlogging_impossible_mode | IGNORE_ERROR
| expire_logs_days | 0
| general_log | ON
| general_log_file | E:/mysqllog/my.log
开启日志
mysql> SET GLOBAL general_log = 'On';
指定日志文件
mysql> SET GLOBAL general_log_file = 'E:/mysqllog
/my.log';