Log in to MySQL via console:
1 |
mysql -u root -p |
Run:
1 2 |
SET global log_output = 'table'; SET global general_log = 1; |
View table mysql.general_log e.g. with phpMyAdmin or command:
1 |
select * from mysql.general_log |
Do not forget to disable logging again:
1 |
SET global general_log = 0; |
Comments