Skip to content

Instantly share code, notes, and snippets.

@tranquangchau

tranquangchau/Log all queries in mysql

Created August 23, 2015 05:52
Show Gist options
  • Save tranquangchau/18695b4b8f92f23db584 to your computer and use it in GitHub Desktop.
Save tranquangchau/18695b4b8f92f23db584 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Log all queries in mysql
[mysqld]
general_log = on
general_log_file=/usr/log/general.log
in your my.cnf / my.ini file
Ubuntu/Debian: /etc/mysql/my.cnf
Windows: c:\ProgramData\MySQL\MySQL Server 5.x
wamp: c:\wamp\bin\mysql\mysqlx.y.z\my.ini
xampp: c:\xampp\mysql\bin\my.ini.
http://stackoverflow.com/questions/303994/log-all-queries-in-mysql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment