#### 通用日志 作用 : 記錄建立的客戶端連接和執行的語句。 #### 查看通用日志狀態 ~~~ 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, ~~~