Search code examples
mariadbmysql-slow-query-logmariadb-10.4

query logging in MariaDB on Windows 10

How to enable {all type of, not just slow} query logging to FILE in MariaDB Server version: 10.4.11 running on Windows 10 ? I have modified my.ini file and added these line at the bottom but it did not worked

[mariadb]
log_output=FILE
general_log
general_log_file=queries.log

I have executed the same in console too with admin privilege but nothing happened, no error was either produced.

Solution

  • Added at the bottom of my.ini and restarted MySQL

    [mariadb]
general_log=1
log_output=FILE
general_log_file=queries.log

    File created under mysql\data\queries.log