View MySQL records executed SQL

First Kind : Check Slow Query of the SQL Grammar :

 

long_query_time = 2 ( more than Span style= "font-family: ' Times New Roman '" >2 seconds sql syntax recorded It is also a way to set a short point to record the error. )

The second Kind : Set MySQL Replication with Binlog:

Log_bin =/var/log/mysql/mysql-bin.log ( This file is to be seen with the mysqlbinlog solution,

Mysqlbinlog mysql-bin.000042| grep "T_ABC" | grep "Column Value"

)

  MySQL syntax in this But the syntax may be different from what you think This is to be addressed to

Third Kind : recommend this method , will be MySQL every line of instruction executed is recorded . :

log =/tmp/mysql.log

restart MySQL after , Tail-f/tmp/mysql.log you'll see