Search code examples
mysqlloggingprocesslive

Mysql - logging in realtime all queries

I have a simple localhost website i would like to log all queries via mysql or mysql client or mysql plugin or whatever in realtime

So that i can see in realtime which queries are runned from the site

is it possible somehow?

Solution

  • Ok at the end i resolved using:

    SET global log_output = 'FILE';
SET global general_log_file='/Applications/MAMP/logs/mysql_general.log';
SET global general_log = 1;

    thanks anyway