Mysql logging

One day or another, you'll want to check what exactly your MySQL server is doing (to check for SQL injections for instance). Therefore:
  • To log all SQL queries, add the following to your my.cnf (in the [mysqld] section)
  • To log queries that actually modify the database:
    If you don't modify the default log-bin parameters, this would create a <servername>-bin.###### & index in your /var/lib/mysql, which you can then analyze with mysqlbinlog

No comments:

Post a Comment

Note: only a member of this blog may post a comment.