Enable MySQL general log

mysql_loging.sql

-- you can enable the log by change my.cnf settings (not recommended)
-- you can make changes on demand via your sql program, e.g workbench (recommended)
-- run the following commands to enable logging on demand.

# specify location for your log. Mysql needs write access to the folder specified
set global general_log_file = '/var/log/mysql/mysql.log';

# turn on login (1), turn off logging (0)
set global general_log = 1;

# see if your settings took effect
show variables like '%general_log%';