Open my.ini file
in
[mysqld] below
LOG = C: /MYSQL_QUERY.LOG.TXT
Restart mysql
In the future, you can use EditPlus to view the SQL you run with EditPlus, don't have to play with LOG in a program.
Attached: mysql doc:
Http://dev.mysql.com/doc/mysql/EN/log_files.html
Log File Types of Information Logged to File The error log Logs problems encountered starting, running, or stopping mysqld. The isam log Logs all changes to the ISAM tables. Used only for debugging the isam code. The query log Logs established client connections and executed statements. The update log Logs statements that change data. This log is deprecated. The binary log Logs all statements that change data. Also used for replication. The slow log Logs all queries that took more than long_query_time seconds to execute or did not use Indexes.
