DelphiFAQ Home Search:
General :: Databases :: mysql
General information about mysql - how to get around the differences between version 3.33 an 4, how to do stuff that you think you need a nested query for etc.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

How to log all mysql database modifications

Question:

How can we log changes done to our mysql production database? People here use the mysql shell as their client.

Answer:

You can specify tee=/var/logs/mysql_cli.log in the mysql shell config file (my.cnf) and it will log all CLI session content (input and output) to this file.

Considering that these CLI modifications can be very powerful, you really should log them.

This does not help if some users use a web front end e.g. phpmyadmin.


[root@www etc]# pwd
 /etc
 [root@www etc]# cat my.cnf
 [client]
 tee=/Content/tmp/mysql_cli.log
 [root@www etc]#
 

Generated 16:00:36 on Oct 19, 2017