mysql记录所有执行过的sql语句

[mysqld]

port            = 3306

socket          = /appl/mysql/mysql.sock

skip-external-locking

key_buffer_size = 16M

max_allowed_packet = 100M

table_open_cache = 64

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M

datadir=/appl/db/mysql/data

character_set_server=utf8

#skip-grant-tables

 

#log=/appl/mysql/mysqld_show.log

log-error=/appl/mysql/mysqld_err.log

log-bin=/appl/mysql/mysqld_bin.bin

general_log=ON

general_log_file=/appl/mysql/mysqld_show.log

 

新增general_log和general_log_file参数即可

早期的log=/appl/mysql/mysqld_show.log已经弃置不用了