Page 1 of 1

How to turn on MySQL commands log

Posted: 25 Feb 2021 05:16
by webguyz
Trying to view a log of all SQL scripts sent to the Mariadb server to learn how to create a few scripts I want to run from an external server to keep an eye on total emails sent in one day and be alerted if any one from address is sending more then 200-300 emails which might indicate a email account thats been hacked

Tried adding this to maria.conf

[mariadb]
general_log = 1
general_log_file = /var/log/mysql.log

But it never gets generated. Any who knows how to get a log I can few of all SQL commands?

Thanks