Labels

Android (1) bash (2) boost (2) C (34) C++ (2) cheatsheet (2) CLion (6) css (3) Debian (33) DL (17) Docker (2) Dreamweaver (2) Eclipse (3) fail2ban (4) git (5) GitHub (4) Hacking (3) html (8) http (1) iOS (1) iPad (1) IRC (1) Java (31) javascript (3) Linux (167) Mac (19) Machine Learning (1) mySQL (48) Netbeans (4) Networking (1) Nexus (1) OpenVMS (6) Oracle (1) Pandas (3) php (16) Postgresql (8) Python (9) raid (1) RedHat (14) Samba (2) Slackware (47) SQL (14) svn (1) tar (1) ThinkPad (1) Virtualbox (3) Visual Basic (1) Visual Studio (1) Windows (2)

Thursday, 21 December 2023

MySQL general query log

To add the general log, add the following entries into the cnf ile;

general_log_file        = /var/log/mysql/mysql.log

general_log             = 1

The logging can also be stated and stopped from the command line;

SET GLOBAL general_log = 'OFF';
SET GLOBAL general_log = 1; 
 
See also here 

No comments:

Post a Comment

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