mysql开启sql执行日志

进入mysql

vagrant@vagrant-ubuntu:~$ mysql -h127.0.0.1 -uroot -p
Enter password:

查询状态

mysql> show variables like 'general_log%';
+------------------+-----------------------------------+
| Variable_name    | Value                             |
+------------------+-----------------------------------+
| general_log      | OFF                               |
| general_log_file | /var/lib/mysql/vagrant-ubuntu.log |
+------------------+-----------------------------------+
2 rows in set (0.00 sec)

可以看到日志状态是关闭的，同时我们还可以看到日志保存的文件路径

开启 并且修改日志路径

mysql> set global general_log=ON;
Query OK, 0 rows affected (0.00 sec)

mysql> set global general_log_file='/var/log/mysql/exec_sql.log';
Query OK, 0 rows affected (0.01 sec)

再次查询状态

mysql> show variables like 'general_log%';
+------------------+-----------------------------+
| Variable_name    | Value                       |
+------------------+-----------------------------+
| general_log      | ON                          |
| general_log_file | /var/log/mysql/exec_sql.log |
+------------------+-----------------------------+
2 rows in set (0.00 sec)

mysql> exit

进行查询

vagrant@vagrant-ubuntu:/var/log/mysql$ tail -f exec_sql.log 
/usr/sbin/mysqld, Version: 5.5.52-0ubuntu0.12.04.1 ((Ubuntu)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
181205 17:25:14      115 Query    show variables like 'general_log%'