方法一: 更改 my.cnf 配置文件
vi /usr/local/kkmail/config/mysql/my.cnf
将下面两行注释取消掉, 然后重启 mysql
- #general_log = 1
- #general_log_file = /tmp/kkmail_mysql.log
- # 设置 general log 保存路径
- # 好像只能设置保存到 /tmp 或 /var 文件夹下
方法二: 在 mysql 命令控制台操作
- # 需要 root 用户才有访问此文件的权限
- mysql> show global variables like '%general%';
- +------------------+----------------------------------------------------+
- | Variable_name | Value |
- +------------------+----------------------------------------------------+
- | general_log | OFF |
- | general_log_file | /usr/local/kkmail/data/mysql/default/localhost.log |
- +------------------+----------------------------------------------------+
- 2 rows in set (0.00 sec)
- mysql> set global general_log_file='/tmp/kkmail_mysql.log';
- Query OK, 0 rows affected (0.00 sec)
- mysql> set global general_log=on;
- Query OK, 0 rows affected (0.05 sec)
- mysql> show global variables like '%general%';
- +------------------+----------------------+
- | Variable_name | Value |
- +------------------+----------------------+
- | general_log | ON |
- | general_log_file | /tmp/kkmail_mysql.log |
- +------------------+----------------------+
- 2 rows in set (0.00 sec)
- mysql> set global general_log=off;
- Query OK, 0 rows affected (0.00 sec)
- mysql> show global variables like '%general%';
- +------------------+----------------------+
- | Variable_name | Value |
- +------------------+----------------------+
- | general_log | OFF |
- | general_log_file | /tmp/kkmail_mysql.log |
- +------------------+----------------------+
- 2 rows in set (0.00 sec)
方法三: 将日志保存在 mysql 数据库 general_log 表中
- mysql> set global log_output='table';
- Query OK, 0 rows affected (0.00 sec)
- mysql> show global variables like '%general%';
- +------------------+----------------------+
- | Variable_name | Value |
- +------------------+----------------------+
- | general_log | OFF |
- | general_log_file | /tmp/kkmail_mysql.log |
- +------------------+----------------------+
- 2 rows in set (0.00 sec)
- mysql> set global general_log=on;
- Query OK, 0 rows affected (0.00 sec)
- mysql> show global variables like '%general%';
- +------------------+----------------------+
- | Variable_name | Value |
- +------------------+----------------------+
- | general_log | ON |
- | general_log_file | /tmp/kkmail_mysql.log |
- +------------------+----------------------+
- 2 rows in set (0.01 sec)
- mysql> use mysql
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Database changed
- mysql> select * from general_log;
来源: http://www.bubuko.com/infodetail-2528009.html