enable mysql query log enable mysql query log windows windows

enable mysql query log


Using the WAMPServer menu system edit the my.ini file. WAMPServer uses a my.ini and not a my.cnf

(left click wampmanager) wampmanager->MySQL->my.ini

This will open the correct my.ini file with notepad.

Check for these parameters and if they dont exists add them under the section heading [wampmysqld] or if you are using 64bit WAMPServer the [wampmysqld64]

NOTE: If you are using the 64bit WAMPServer you may have to change [wampmysqld] to [wampmysqld64] as the 64bit release had a little bug in it and this section header was not set correctly. The filename may also be c:\wamp64 on 64bit WAMPServer systems.

log-output = FILEgeneral_log = 1general_log_file=C:/wamp/logs/general-query.log

Save the file and then restart MySQL Server (restart WAMP in your case)

Check in the C:\wamp\logs folder for the new general-query.log file.


If 64bit version, be sure the log will be created in "C:/wamp64/logs/general-query.log"instead of "C:/wamp/logs/general-query.log".