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 is a command-line client for performing administrative operations on MySQL servers. It can check server status, create and drop databases, reload privileges, flush logs, and shut down the server.Common administrative tasks include checking if the server is alive (ping), viewing server variables and status counters (variables, extended-status), reloading grant tables after permission changes (flush-privileges), and monitoring active connections (processlist).
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.flush-privileges
Reload grant tables.extended-status
Show server status variables.--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)
