How can I start and check my MySQL log

Question

I want to check the log in MySQL to see the queries that are being run by my application  How can I do this  I am using XAMPP and the directory to MySQL is C  xampp mysql   This is what I get when I do show variables like   log     mysql gt  show variables like   log     --------------------------------- ------------------------------------    Variable name                     Value                                 --------------------------------- ------------------------------------    back log                          50                                     binlog cache size                 32768                                  binlog format                     STATEMENT                              expire logs days                  0                                      general log                       OFF                                    general log file                  C  xampp mysql data mysql log          innodb flush log at trx commit    1                                      innodb locks unsafe for binlog    OFF                                    innodb log buffer size            8388608                                innodb log file size              5242880                                innodb log files in group         2                                      innodb log group home dir         C  xampp mysql data                    innodb mirrored log groups        1                                      log                               OFF                                    log bin                           OFF                                    log bin trust function creators   OFF                                    log bin trust routine creators    OFF                                    log error                         C  xampp mysql data mysql err          log output                        FILE                                   log queries not using indexes     OFF                                    log slave updates                 OFF                                    log slow queries                  OFF                                    log warnings                      1                                      max binlog cache size             4294963200                             max binlog size                   1073741824                             max relay log size                0                                      relay log                                                                relay log index                                                          relay log info file               relay-log info                         relay log purge                   ON                                     relay log space limit             0                                      slow query log                    OFF                                    slow query log file               C  xampp mysql data mysql-slow log     sql log bin                       ON                                     sql log off                       OFF                                    sql log update                    ON                                     sync binlog                       0                                     --------------------------------- ------------------------------------  37 rows in set  0 00 sec

User · Answer

Set up the General Query Log

User · Answer

Enable general query log by the following query in mysql command line  SET GLOBAL general log    ON     Now open C  xampp mysql data mysql log and check query log  If it fails  open your my cnf file  For windows its my ini file and enable it there  Just make sure its in the  mysqld  section   mysqld  general log               1   Note  In xampp my ini file can be either found in xampp mysql or in c  windows directory

User · Answer

Seems like the general query log is the file that you need  A good introduction to this is at http   dev mysql com doc refman 5 1 en query-log html

User · Answer

For me  general log didn t worked  But adding this to my ini worked   mysqld  log-output FILE slow query log   1 slow query log file    d  temp developer log

User · Answer

Its given on OFFICIAL MYSQL website   SET GLOBAL general log    ON     You can also use custom path    mysqld    Set Slow Query Log long query time   1 slow query log   1 slow query log file    C  slowquery log    Set General Log log    C  genquery log

[mysql] How can I start and check my MySQL log?

Examples related to mysql

Examples related to logging