MySQL modify configuration enables MySQL-brought logs

in the project development is always to see the background execution of SQL statements, MySQL database is no exception, its view of the general people like to use show Processlist ; command to resolve, the type of SQL statements executed can be analyzed in the field interpretation of the output results inside, but not well suited to the general beginner, so it is the most straightforward way to view SQL statements through a log file.

First you need to create a log file log.txt , such as I directly saved in the MySQL directory in the middle of the data directory, and then only need to MySQL configuration file My.ini last added

log=c:/mysql5/system.log

This allows you to record all the SQL statements executed by MySQL!

MySQL modify configuration enables MySQL-brought logs