mysqladmin

Safemysqladmin one-liners

mysqladmin -u root -p status

Quick admin checks from the shell — ping for liveness, status and processlist for at-a-glance state.

Examples

mysqladmin -u monitor -p pingIs MySQL alive?

Syntax

mysqladmin -u u -p [status|ping|processlist|flush-logs]

Before you run it

Mostly reads; flush ops have effects.

Related commands

Connect (psql/mysql/sqlcmd)Connect to a DB
SHOW STATUS / VARIABLESServer status & variables

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store