#### 通用日志 作用 : 记录建立的客户端连接和执行的语句。 #### 查看通用日志状态 ~~~ show variables like '%general%'; ~~~ ~~~ +------------------+------------------------------+ | Variable_name | Value | +------------------+------------------------------+ | general_log | OFF | //是否开启,on为开启 | general_log_file | /var/lib/mysql/localhost.log | //存放位置 +------------------+------------------------------+ ~~~ #### 开启通用日志 ~~~ set global general_log = on; ~~~ #### 打开文件查看结果 ~~~ Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock 3 Time Id Command Argument 4 2018-03-26T09:33:30.675677Z 17 Query SELECT DATABASE() 5 2018-03-26T09:33:30.676075Z 17 Init DB test 6 2018-03-26T09:33:30.677162Z 17 Query show databases 7 2018-03-26T09:33:30.678122Z 17 Query show tables 8 2018-03-26T09:33:54.115122Z 17 Query show tables 9 2018-03-26T09:34:18.237418Z 17 Query show tables 10 2018-03-26T09:35:48.958240Z 17 Query show tables 11 2018-03-26T09:37:38.975618Z 17 Query create table user( 12 id int auto_increment primary key, ~~~