Turn MySQL logging on & off

sqlog

#!/bin/sh
if [ "$1" = "on" ]; then
  mysql -e 'SET GLOBAL log_output = "FILE"; SET GLOBAL general_log_file = "/tmp/mysql.log"; SET GLOBAL general_log = "ON";'
  echo "mysql log ON: /tmp/mysql.log"
elif [ "$1" = "off" ]; then
  mysql -e 'SET GLOBAL general_log = "OFF";'
  echo "mysql log OFF"
elif [ "$1" = "tail" ]; then
  mysql -e 'SET GLOBAL log_output = "FILE"; SET GLOBAL general_log_file = "/tmp/mysql.log"; SET GLOBAL general_log = "ON";'
  echo "tailing mysql log /tmp/mysql.log..."
  tail -f /tmp/mysql.log
else
  echo "Usage: sqlog on|off|tail"
fi