MySQL/MariaDB Ready

Slug

6W6D1MY48E1B

Fetches

0

Size

993 B · 41 lines

Expires

never

Last fetch

—

Created

2026-09-07 00:35:59.842

Description

mysqladmin ping against the local server

#!/usr/bin/env bash
# MySQL / MariaDB readiness
# Read-only: mysqladmin ping. Does not modify schemas or data.
# Exit 0 if alive, 1 if mysqladmin is missing, 2 if the server does not reply.
# Hosted on Runny.sh. Review the script page before you run it.

set -u

note() { printf '%s\n' "$*"; }

note "=== MySQL/MariaDB readiness ==="
if ! command -v mysqladmin >/dev/null 2>&1; then
  note "mysqladmin not found in PATH"
  note "Result: WARNING"
  exit 1
fi

note "Client:   $(mysqladmin --version 2>/dev/null || printf unknown)"
note "Args:     ${*:-<defaults>}"
note ""
out=$(mysqladmin "$@" ping 2>&1 || true)
out=${out#$'\a'}
note "$out"
case "$out" in
  *[Aa]live*)
    note "          OK"
    note "Result: HEALTHY"
    exit 0
    ;;
  *[Aa]ccess\ [Dd]enied*)
    note "          WARNING: server answered but authentication failed"
    note "Result: WARNING"
    exit 1
    ;;
  *)
    note "          CRITICAL: mysqladmin ping failed"
    note "Result: CRITICAL"
    exit 2
    ;;
esac