How to enable MySQL Query Log?

If you don’t want or cannot restart the MySQL server you can proceed like this on your running server:

• Create your log tables (see answer)

• Enable Query logging on the database (Note that the string ‘table’ should be put literally and not substituted by any table name. Thanks Nicholas Pickering)

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

• View the log

select * from mysql.general_log;

• Disable Query logging on the database

SET global general_log = 0;