How to log all the queries in mysql or mariadb - windows and linux

Log all your sql queries on mysql server

Note: use only on your Test Server and without a lot of workload or connections othewise you are going to fill all your disk space or the IO resources (and even the CPU load to wait for IO writing).

Make sure that your logs folder exists and use the same folder of other mysql logs (ex. /var/log/mysql/)

Add in your my.ini/my.cnf (or server.cnf)


on Windows:

general_log_file="C:/yourWindowsMysql/logs/logsql.log"
general_log=1

on linux *unix add:

general_log_file="/var/log/mysqld-queries.log"
general_log=1

 restart your mysql or mariadb server