MySQL Commands

- Enable/disable MySQL general log (query log)

  % set global general_log = 'ON'   (or 'OFF')

The file is output to hostname.log by default or we can specify file name in my.ini with "log=fileName"

- Turn on/off Foreign Key checks for dropping schema

  % set foreign_key_checks = 1;  (or 0 to turn off)

- Check version

  % status;