MySQL: Enable query logging during runtime without restart

mysql -u root -p

1	mysql -u root -p

Run:

SET global log_output = 'table';
SET global general_log = 1;

1 2	SET global log_output = 'table'; SET global general_log = 1;

View table mysql.general_log e.g. with phpMyAdmin or command:

select * from mysql.general_log

1	select * from mysql.general_log

Do not forget to disable logging again:

SET global general_log = 0;

1	SET global general_log = 0;