Mysql displays SQL statements executed by tracking logs

In SQL server, how does one track SQL using an event probe?

In fact, the method is very simple. Enable the mysql log function and view the tracking log.

How to enable mysql log:

Configuration method in windows:

My Version: 5.0.37-community-nt-log (MySQL Community Edition (GPL ))

Find my. ini in the "G: \ Program Files (x86) \ MySQL Server 5.0" directory,

Find [mysqld] and add it below:

Log = path for storing logs/my. log

My configuration values:

 

Save the file, restart the service, and find the "MySQL. log" file in the "G: \ Program Files (x86) \ MySQL \ mySQL Server 5.0 \ data" directory.

Configuration method in linux:

Modify/etc/my. cnf, find [mysqld], and add it below:

Log = path for storing logs/my. log

After modification, restart the mysql service.