login to ssh console
ssh This email address is being protected from spambots. You need JavaScript enabled to view it.
then login to mysql console
mysql -u root -p YourRootPassword
then insert this query
SHOW VARIABLES LIKE "general_log%
this will show this table
mysql> SHOW VARIABLES LIKE "general_log%";
+------------------+--------------------------+
| Variable_name | Value |
+------------------+--------------------------+
| general_log | ON |
| general_log_file | /var/log/mysql/mysql.log |
+------------------+--------------------------+
2 rows in set (0.00 sec)
we set to ON for get the full mysql query logs
mysql> SET GLOBAL general_log = 'ON';
Query OK, 0 rows affected (0.00 sec)
turn it off soon you have finish for keep space
mysql> SET GLOBAL general_log = 'OFF';