#!/bin/bash
PATH=/bin:/sbin:/usr/bin:/usr/sbin
HOST=$1
USER=$2
PASS=$3
WARN=$4
CRIT=$5
EOF="\015\012"
BLANK=$EOF$EOF
STATUS=`mysql -h $HOST -u $USER -p$PASS -e "show processlist;" | grep -v localhost | wc | awk '{print $1}'`

if [ $STATUS -lt $4 ]; then
  echo "OK - $STATUS MySQL user connections"
  exit 0
else if [ $STATUS -lt $5 ]; then
  echo "WARNING - $STATUS MySQL user connections"
  exit 1
else if [ $STATUS -ge $5 ]; then
  echo "CRITICAL - $STATUS MySQL user connections"
  exit 2
else
  echo "UNKNOWN - $STATUS"
  exit 3
fi