You are here

sql

Enabling logging for your MySQL queries from the MySQL prompt

Submitted by Druss on Sat, 2016-06-04 01:44

I usually find it a chore to edit the MySQL conf files (as for one, I often have no idea which my.cnf file to edit!) One way to work around this issue, particularly if you want to change a setting temporarily, is to simply enable the change dynamically via the MySQL command prompt. This can be accomplished by modifying "global" variables which can be listed with commands like so:

Subscribe to RSS - sql