MySQL Server 5.5 Logging on Windows 7

First you need to find out which settings file is active. Usually you can find it under C:\ProgramData\MySQL\MySQL Server 5.5\my.ini. Then you need to add the output configuration. Be careful to use the right syntax for the path. Below [mysqld] you can add something like:

log-output=FILE 
general_log = 1 
general_log_file = "C:/mysql-queries.log"

After you restart the service your queries will be logged. If it doesn't work you can consult the Errorfile (C:\ProgramData\MySQL\MySQL Server 5.5\data\computername.err)

 

Leave a comment

Your email address will not be published. Required fields are marked *