mysqladmin
administers MySQL servers
TLDR
Check server status
$ mysqladmin -u [user] -p status
Create database$ mysqladmin -u [user] -p create [database_name]
Drop database$ mysqladmin -u [user] -p drop [database_name]
Change password$ mysqladmin -u [user] -p password "[newpassword]"
Show variables$ mysqladmin -u [user] -p variables
Show process list$ mysqladmin -u [user] -p processlist
Shutdown server$ mysqladmin -u [root] -p shutdown
Ping server$ mysqladmin -u [user] -p ping
SYNOPSIS
mysqladmin [options] command
DESCRIPTION
mysqladmin administers MySQL servers. It performs administrative operations.
The tool manages databases, users, and server state. Essential for DBA tasks.
PARAMETERS
COMMAND
Administration command.-u USER
Username.-p [PASSWORD]
Password.-h HOST
Server hostname.status
Show server status.create DB
Create database.drop DB
Drop database.--help
Display help information.
CAVEATS
Requires admin privileges. Dangerous operations (drop). Use carefully in production.
HISTORY
mysqladmin is part of the MySQL distribution, providing command-line administration since early versions.
SEE ALSO
mysql(1), mysqldump(1), mysqlcheck(1)