Bash function to connect to a third party mysql server through a SSH connection

mysql3rdpartytunnel.sh

mysql3rdpartytunnel() {
  SSH_HOST="<SSH HOST USE .SSH/CONFIG>"
  MYSQL_HOST="<THIRD PARTY MYSQL SERVER>"
  MYSQL_USER="<MYSQL SERVER USER>"
  MYSQL_PASSWORD="<MYSQL PASSWORD>"
  MYSQL_DEFAULT_SCHEMA=""
  LOCALPORT=33061
  
  SOCKET="/tmp/ssh-tunnel-$SSH_HOST-$RANDOM"
  echo "Opening SSH socket $SOCKET..."
  ssh -S $SOCKET -L $LOCALPORT:$MYSQL_HOST:3306 -NMf $SSH_HOST
  if [ -S "$SOCKET" ]; then
    mysql -h 127.0.0.1 -P $LOCALPORT -u $MYSQL_USER --password=$MYSQL_PASSWORD $MYSQL_DEFAULT_SCHEMA
    echo "Closing socket..."
    ssh -S $SOCKET -O exit dummy_arg
  else
    echo "Error while opening SSH tunnel"
  fi
}